How to call a stored procedure that is inside a package and takes parameter as RECORD TYPE for testing purposes. The procedure is not exposed in the package.
--1)Cursor has a query 2)Cursor fetches data in Row Type 3) into list of variables
--Part 1: Cursor declaration --- cursor abc_cursor select col_name from table_name;
--Part 2 Cursor assigned to rowtype--- abc_record abc_cursor % ROWTYPE;
-- Part 3 record passes into parameter PROCEDURE PROC_NAME (abc_info IN abc_record%type) DBMS_OUTPUT.PUT_LINE(abc_info.variable1); DBMS_OUTPUT.PUT_LINE(abc_info.variable2); -- lots of code --- End PROC_NAME;