I have oracle procedure in package. How I execute it and get out parametres?
Example:
declare
pOprList clob;
pResult number;
pResMsg varchar2(250);
begin
package.procedure(pusrcode => ‘TEST’, --in
pdepid => ‘123’, --in
pid => ‘3456’, --in
poprlist => pOprList, --out
presult => pResult, --out
presmsg => pResMsg); --out
DBMS_OUTPUT.put_line(poprlist);
end;