** pass table in a script to execute PL/SQL (procedure)
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 15 Oct 2004 12:29:33 -0700 (PDT)
Hi,
I am looking for a way to pass table to a SP as input in a test script like I
pass number, varchar2 fields.
I defined the table as input to the SP as follows:
create type t_type (a number(10), b varchar2(10), c number(2));
create type t_tbl as table of t_type;
procedure (t_tbl_inp in t_tbl,
t_tbl_out out t_tbl,
ind out number);
I would like to pass the input parameter t_tbl_inp to the SP and then look at
the output t_tbl_out.
Thanks for your help.
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
