Re: Help with procedure having table as a parameter
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 08 Jun 2011 19:03:36 +0200
Message-ID: <4defab68$0$14263$ba620e4c_at_news.skynet.be>
Date: Wed, 08 Jun 2011 19:03:36 +0200
Message-ID: <4defab68$0$14263$ba620e4c_at_news.skynet.be>
Maikku wrote:
> procedure example_caller is
> example_table type_table := type_table();
> begin
> example_proc(example_table);
> dbms_output.put_line('caller :'||example_table(1).col1);
> dbms_output.put_line('caller:'||example_table(2).col2);
> end;
something like
declare
example_table example_p.type_table := example_p.type_table(); begin
example_p.example_proc(example_table);
dbms_output.put_line('caller :'||example_table(1).col1);
dbms_output.put_line('caller:'||example_table(2).col2);
end;
/
?? Received on Wed Jun 08 2011 - 19:03:36 CEST