Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 19805 invoked from network); 13 Apr 2006 17:37:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 13 Apr 2006 17:37:27 -0000 Received: (qmail 43769 invoked by uid 500); 13 Apr 2006 17:37:23 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 43738 invoked by uid 500); 13 Apr 2006 17:37:23 -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 43727 invoked by uid 99); 13 Apr 2006 17:37:23 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Apr 2006 10:37:23 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [68.142.198.210] (HELO smtp111.sbc.mail.mud.yahoo.com) (68.142.198.210) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 13 Apr 2006 10:37:22 -0700 Received: (qmail 45672 invoked from network); 13 Apr 2006 17:37:01 -0000 Received: from unknown (HELO ?127.0.0.1?) (ddebrunner@sbcglobal.net@71.132.3.188 with plain) by smtp111.sbc.mail.mud.yahoo.com with SMTP; 13 Apr 2006 17:36:59 -0000 Message-ID: <443E8C27.7080802@apache.org> Date: Thu, 13 Apr 2006 10:36:39 -0700 From: Daniel John Debrunner User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en, de MIME-Version: 1.0 To: Derby Discussion Subject: Re: Can A Function or procedure return multiple values !! References: <416061d0604122101v531f98dbq4a78b08c0c60e20f@mail.gmail.com> In-Reply-To: <416061d0604122101v531f98dbq4a78b08c0c60e20f@mail.gmail.com> X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Dheeraj Dhiman wrote: > I m using apache derby for my Project !! > In this project we want to make a function > which accecpt three long argument & i want to return Object[] ( Object Array > ) !! > Can this is possible in apache derby if yes then pls give example !! No, Derby does not support array types. A procedure can return one or more JDBC ResultSets from server-side JDBC queries. I've added some examples to this page today. http://wiki.apache.org/db-derby/DerbySQLroutines Dan.