** test a SP with table input at SQL prompt

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Wed, 8 Dec 2004 07:56:13 -0800 (PST)
Message-ID: <20041208155613.28892.qmail@web60710.mail.yahoo.com>

Hi,
  I have a stored procedure which has a input parameter of type table of a object. I am trying to test it at SQL level with PL/SQL block. I am able to assign values to other data types but I do not know how to do it for type table. Can some one help? Thanks  

I have :  

CREATE TYPE obj1 AS OBJECT
(emp_no number,
 emp_name varchar2(20));  

CREATE TYPE tab_obj1 AS TABLE OF obj1;  

PROCEDURE proc1 (

               in_objs        tab_obj1,
               dept            varchar2(10),
               flag       out number);
 

I am testing procedure proc1 at SQL level. Iwould like to set the values emp_no= 112, emp_name = 'JO', emp_no=114, emp_name = 'RA'. Thanks for your help.                     

---

Do you Yahoo!?
 Yahoo! Mail - Helps protect you from nasty viruses.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 08 2004 - 10:00:47 CST