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