Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 9060 invoked from network); 2 Feb 2006 18:09:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Feb 2006 18:09:13 -0000 Received: (qmail 19073 invoked by uid 500); 2 Feb 2006 18:09:11 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 18856 invoked by uid 500); 2 Feb 2006 18:09:10 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 18839 invoked by uid 99); 2 Feb 2006 18:09:10 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Feb 2006 10:09:10 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.98.34] (HELO brmea-mail-3.sun.com) (192.18.98.34) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Feb 2006 10:09:08 -0800 Received: from phys-mpk-1 ([129.146.11.81]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id k12I8mQj013696 for ; Thu, 2 Feb 2006 11:08:48 -0700 (MST) Received: from conversion-daemon.mpk-mail1.sfbay.sun.com by mpk-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0IU200H01MDONZ@mpk-mail1.sfbay.sun.com> (original mail from David.Vancouvering@Sun.COM) for derby-dev@db.apache.org; Thu, 02 Feb 2006 10:08:48 -0800 (PST) Received: from [129.150.26.90] (vpn-129-150-26-90.SFBay.Sun.COM [129.150.26.90]) by mpk-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <0IU20039TNOYZB@mpk-mail1.sfbay.sun.com> for derby-dev@db.apache.org; Thu, 02 Feb 2006 10:07:47 -0800 (PST) Date: Thu, 02 Feb 2006 10:07:56 -0800 From: "David W. Van Couvering" Subject: Re: And another metadata question In-reply-to: <43E24428.9040205@apache.org> To: derby-dev@db.apache.org Message-id: <43E24A7C.60800@sun.com> MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_7d3bF8QFisMQmq/hC6LYhA)" X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) References: <43E23E78.4090604@sun.com> <43E24125.509@apache.org> <43E24428.9040205@apache.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. --Boundary_(ID_7d3bF8QFisMQmq/hC6LYhA) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT Great thanks, I'll return 'true' to this question for the new JDBC4 metadata methods. David Daniel John Debrunner wrote: > Daniel John Debrunner wrote: > > >>David W. Van Couvering wrote: >> >> >> >>>Does Derby support calling user-defined stored procedures or functions >>>using the stored procedure escape syntax? >> >> >>Yes for procedures, search for the reqular expression '\{.*call' in >>procedure.java. >> >>Possibly for functions, since I'm modifying functions.sql I can add some >>tests there to see. > > > Yes for functions, of course it has to be a java test because the syntax is > {? = call function(...) } > > (to fetch the out parameter, ij doesn't support getting the parameter). > > This is already tested in outparams.java > > Dan. > --Boundary_(ID_7d3bF8QFisMQmq/hC6LYhA) Content-type: text/x-vcard; charset=utf-8; name=david.vancouvering.vcf Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=david.vancouvering.vcf begin:vcard fn:David W Van Couvering n:Van Couvering;David W org:Sun Microsystems, Inc.;Database Technology Group email;internet:david.vancouvering@sun.com title:Senior Staff Software Engineer tel;work:510-550-6819 tel;cell:510-684-7281 x-mozilla-html:TRUE version:2.1 end:vcard --Boundary_(ID_7d3bF8QFisMQmq/hC6LYhA)--