Received: from lukla.Sun.COM (lukla.Sun.COM [192.18.98.31]) by hub.org (8.10.1/8.10.1) with ESMTP id e5T2Uc180555 for ; Wed, 28 Jun 2000 22:30:38 -0400 (EDT) Received: from engmail3.Eng.Sun.COM ([129.144.170.5]) by lukla.Sun.COM (8.9.3+Sun/8.9.3) with ESMTP id UAA14223 for ; Wed, 28 Jun 2000 20:30:37 -0600 (MDT) Received: from neb4.eng.sun.com (neb4.Eng.Sun.COM [192.29.219.120]) by engmail3.Eng.Sun.COM (8.9.3+Sun/8.9.3/ENSMAIL, v1.7) with ESMTP id TAA09071 for ; Wed, 28 Jun 2000 19:30:35 -0700 (PDT) Received: from mailcity.com (localhost [127.0.0.1]) by neb4.eng.sun.com (8.9.3+Sun/8.9.3) with ESMTP id TAA20802 for ; Wed, 28 Jun 2000 19:29:49 -0700 (PDT) Message-ID: <395AB49C.D924C245@mailcity.com> Date: Wed, 28 Jun 2000 19:29:48 -0700 From: Nitin Bahadur Reply-To: bnitin@mailcity.com Organization: SUN X-Mailer: Mozilla 4.51 [en] (X11; U; SunOS 5.8 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: SQL stored procedures and JDBC problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/8 I need a SQL stored procedure to return arrays. as OUT parameters in If i declare the array as a "table", then i cannot do table[i] := some_value. If i declare it as a VARRAY. then i need to initialialize all my VARRAY elements using a costructor which is painful ( a simple for loop does not do it). So how do i declare and use arrays in SQL stored procedures so as to return arrays as OUT paramters and access the same in JDBC kindly reply at bnitin@mailcity.com thanks nitin