From oracle-l-bounce@freelists.org Fri Mar 26 08:19:46 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2QEJjK23606 for ; Fri, 26 Mar 2004 08:19:45 -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 i2QEJjo23599 for ; Fri, 26 Mar 2004 08:19:45 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F9BE390BF6; Fri, 26 Mar 2004 09:16:43 -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 13553-92; Fri, 26 Mar 2004 09:16:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 34D2F390BF0; Fri, 26 Mar 2004 09:16:42 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 26 Mar 2004 09:15:27 -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 D7D14390A95 for ; Fri, 26 Mar 2004 09:15:26 -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 14358-16 for ; Fri, 26 Mar 2004 09:15:26 -0500 (EST) Received: from jands2.bayer.com (host250.bayer.com [192.122.250.250]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 763F6390A3A for ; Fri, 26 Mar 2004 09:15:26 -0500 (EST) Subject: Re: ** pass array To: oracle-l@freelists.org Message-ID: From: Michael Boligan Date: Fri, 26 Mar 2004 09:22:49 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1887 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: michael.boligan.b@bayer.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Better yet, here are a few examples from the expert, Tom Kite. http://osi.oracle.com/~tkyte/ResultSets/index.html |---------+-----------------------------> | | A Joshi | | | | | | Sent by: | | | oracle-l-bounce@fr| | | eelists.org | | | | | | | | | 03/25/2004 05:44 | | | PM | | | Please respond to | | | oracle-l | | | | |---------+-----------------------------> >-----------------------------------------------------------------------------------------------------------------------| | | | To: oracle-l@freelists.org | | cc: | | Subject: Re: ** pass array | >-----------------------------------------------------------------------------------------------------------------------| 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. ---------------------------------------------------------------- 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 -----------------------------------------------------------------