Re: ** pass array

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Thu, 25 Mar 2004 14:44:13 -0800 (PST)
Message-ID: <20040325224413.72374.qmail@web60710.mail.yahoo.com>

Thanks Michael. Can you tell me how ref cursor can be used to pass data from GUI to SP? I am using ref cursor to pass data from SP to GUI.

Michael Boligan <michael.boligan.b_at_bayer.com> wrote:

Look into ref cursors.

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


| | A Joshi |

| | | | 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
-----------------------------------------------------------------


---------------------------------
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 - 16:40:53 CST