Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** pass array

Re: ** pass array

From: Michael Boligan <michael.boligan.b_at_bayer.com>
Date: Thu, 25 Mar 2004 08:58:13 -0500
Message-ID: <OFB2AD4C2F.2C755A71-ON85256E62.004CB770-85256E62.004CBDFF@bayer.com>

Look into ref cursors.

|---------+----------------------------->

| | A Joshi |
| | <ajoshi977_at_yahoo.c|
| | om> |
| | Sent by: |
| | oracle-l-bounce_at_fr|
| | eelists.org |
| | |
| | |
| | 03/25/2004 01:37 |
| | AM |
| | Please respond to |
| | oracle-l |
| | |
|---------+-----------------------------> >-----------------------------------------------------------------------------------------------------------------------| | | | To: oracle-l_at_freelists.org | | cc: | | Subject: ** pass array | >-----------------------------------------------------------------------------------------------------------------------|

Hi,
  Can some one tell me how to pass a array to a procedure when I run the procedure at sqlplus with pl/sql block of a declare begin end.

   I have a procedure that is going to accept as input a set of parameters and a array. IT will insert a row in a parent table with the values of parameters and it will insert multiple rows into a child table with values in the array. Help Examples if any appreciated. What I am doing is

1) declare a array p_array in the pl/sql block and initialize it
2) p_array.extend
3) p_array(1).col1 := 'caleval';  p_array(1).col2 := 'caleval2'; so on

Then apssing it. Howeveer in the SP I am getiing numeric or value error when inerting them to a table. I did check all the variables and they seem to have the values. Same values if I use to insert in sql works fine. So is there a catch? Does any one
 have similar case? Thanks

Thanks

Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Mar 25 2004 - 07:55:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US