Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 57746 invoked from network); 2 Apr 2007 21:59:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Apr 2007 21:59:03 -0000 Received: (qmail 30098 invoked by uid 500); 2 Apr 2007 21:59:09 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 30062 invoked by uid 500); 2 Apr 2007 21:59:08 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 30051 invoked by uid 99); 2 Apr 2007 21:59:08 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Apr 2007 14:59:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [192.18.1.36] (HELO gmp-ea-fw-1.sun.com) (192.18.1.36) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Apr 2007 14:59:00 -0700 Received: from d1-emea-09.sun.com (d1-emea-09.sun.com [192.18.2.119]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l32LwbJ2004861 for ; Mon, 2 Apr 2007 21:58:39 GMT Received: from conversion-daemon.d1-emea-09.sun.com by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JFW00H014ZFXY00@d1-emea-09.sun.com> (original mail from Oystein.Grovlen@Sun.COM) for derby-user@db.apache.org; Mon, 02 Apr 2007 22:58:37 +0100 (BST) Received: from [192.168.0.4] ([80.202.23.210]) by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JFW00H0P51O0V9F@d1-emea-09.sun.com> for derby-user@db.apache.org; Mon, 02 Apr 2007 22:58:37 +0100 (BST) Date: Mon, 02 Apr 2007 23:58:36 +0200 From: =?ISO-8859-1?Q?=D8ystein_Gr=F8vlen?= Subject: Re: Can I pass an array to a stored procedure? In-reply-to: <20070402215126.483A410FB02B@herse.apache.org> Sender: Oystein.Grovlen@Sun.COM To: Derby Discussion Message-id: <46117C8C.4090406@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 8BIT References: <20070402215126.483A410FB02B@herse.apache.org> User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) X-Virus-Checked: Checked by ClamAV on apache.org Brown, Andrew W (Rosetta) wrote: > After reading through the documentation it doesn't seem like passing an > array to a stored procedure is possible: Derby does not support the SQL ARRAY type. So it will not be possible to pass arrays as stored procedures. -- �ystein