For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi ,
How can we pas PL/SQL table parameter type to Stored procedure as input parameter.
Thanks
Vinod
something like this do you need?
{code}
set serveroutput on;
create type complexType as Object
(c_id number);
create type complexTable is table of complexType;
create or replace procedure complexProx(v complexTable)
is
begin
for i in 1..v.count
loop
dbms_output.put_line(v(i).c_id);
end loop;
end;
declare
v_id complexTable := complexTable();
v_id.extend;
for i in 1..10
v_id(i) := complexType(i);
complexProx(v_id);