raw.txt
No One
Actions

Authored By

	swalker
	Sep 4 2019, 8:24 AM

Size

872 B

Referenced Files

None

Subscribers

None

raw.txt
View Options

	CREATE OR REPLACE TYPE stw_ty_row FORCE AS OBJECT(
	company VARCHAR2(4), agreement NUMBER(10), start_date DATE, end_date DATE
	);

	CREATE OR REPLACE TYPE stw_ty_table IS TABLE OF stw_ty_row;

	CREATE PACKAGE mypackage as
	PROCEDURE prc_do_stuff(p_tbl IN stw_ty_table, p_output OUT sys_refcursor);
	END;

	SELECT left.argument_name, left.type_name, right.type_name sub_type_name, left.defaulted defaulted
	FROM user_arguments left
	LEFT JOIN user_arguments right ON (
	right.object_name = left.object_name
	AND (right.package_name = left.package_name OR (right.package_name IS NULL AND left.package_name IS NULL))
	AND right.sequence = left.sequence + 1
	AND left.data_type = 'TABLE'
	)
	WHERE left.object_name = 'PRC_DO_STUFF'
	AND (left.package_name = 'MYPACKAGE' OR 'MYPACKAGE' IS NULL)
	AND left.data_level = 0
	ORDER BY left.sequence;