From oracle-l-bounce@freelists.org Thu Mar 25 16:40:53 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2PMer130812 for ; Thu, 25 Mar 2004 16:40:53 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2PMepo30805 for ; Thu, 25 Mar 2004 16:40:52 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8144D3920E4; Thu, 25 Mar 2004 17:38:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13361-24; Thu, 25 Mar 2004 17:38:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF6FF39199A; Thu, 25 Mar 2004 17:38:09 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 25 Mar 2004 17:36:52 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B5821390C8F for ; Thu, 25 Mar 2004 17:36:51 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11935-35 for ; Thu, 25 Mar 2004 17:36:51 -0500 (EST) Received: from web60710.mail.yahoo.com (web60710.mail.yahoo.com [216.109.117.233]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 44CCB390BDD for ; Thu, 25 Mar 2004 17:36:51 -0500 (EST) Message-ID: <20040325224413.72374.qmail@web60710.mail.yahoo.com> Received: from [209.219.209.68] by web60710.mail.yahoo.com via HTTP; Thu, 25 Mar 2004 14:44:13 PST Date: Thu, 25 Mar 2004 14:44:13 -0800 (PST) From: A Joshi Subject: Re: ** pass array To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1802150098-1080254653=:70982" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1854 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ajoshi977@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --0-1802150098-1080254653=:70982 Content-Type: text/plain; charset=us-ascii 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 wrote: Look into ref cursors. |---------+-----------------------------> | | A Joshi | | | | | om> | | | Sent by: | | | oracle-l-bounce@fr| | | eelists.org | | | | | | | | | 03/25/2004 01:37 | | | AM | | | Please respond to | | | oracle-l | | | | |---------+-----------------------------> >-----------------------------------------------------------------------------------------------------------------------| | | | To: oracle-l@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@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. --0-1802150098-1080254653=:70982 Content-Type: text/html; charset=us-ascii
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@bayer.com> wrote:




Look into ref cursors.


|---------+----------------------------->
| | A Joshi |
| | | | om> |
| | Sent by: |
| | oracle-l-bounce@fr|
| | eelists.org |
| | |
| | |
| | 03/25/2004 01:37 |
| | AM |
| | Please respond to |
| | oracle-l |
| | |
|---------+----------------------------->
>-----------------------------------------------------------------------------------------------------------------------|
| |
| To: oracle-l@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@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. --0-1802150098-1080254653=:70982-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------