** pass table in a script to execute PL/SQL (procedure)

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Fri, 15 Oct 2004 12:29:33 -0700 (PDT)
Message-ID: <20041015192933.25762.qmail@web60708.mail.yahoo.com>

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.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 15 2004 - 14:25:04 CDT