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>


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

Original text of this message