Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 87126 invoked from network); 25 Nov 2009 08:51:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 25 Nov 2009 08:51:10 -0000 Received: (qmail 81621 invoked by uid 500); 25 Nov 2009 08:51:10 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 81543 invoked by uid 500); 25 Nov 2009 08:51: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 81535 invoked by uid 99); 25 Nov 2009 08:51:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Nov 2009 08:51:10 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of shazin.sadakath@gmail.com designates 209.85.222.198 as permitted sender) Received: from [209.85.222.198] (HELO mail-pz0-f198.google.com) (209.85.222.198) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Nov 2009 08:51:07 +0000 Received: by pzk36 with SMTP id 36so754960pzk.5 for ; Wed, 25 Nov 2009 00:50:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=NW1tvnxR5GdAwdpw5lso2IHG8MewVYDivYxuzz7t8eE=; b=QXT3or5GwxdIGgijV5ApLEBQqZ6y90oj2BSFL5q9nZYFCY7uho1dM/4WR0a8b/iGz8 cuBemVo5MHZsGVPupcbB6uZ1XuRu+WP3tLDKAWjrHLd6AL6hmgRDhIix//5+6nOnymMe Je180yUlJLIzJ/FwbwBQhEI65K87Wi+ucYB+M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=XcoJqIHX9sTJNE5ry81PTT/XRe6YgnCTyqU6jdikXzV7yMii09YLsbPGX2Oz+iCaGk VK5UMX/gFmxfiw86QWuRSq0IFkLCjkZTvx/+dlwKz/9Azw/+a08wj8/RFgPfKVWv4sLG H+T116r1DQKw5bJWT71shBvWIl8p/Cedh3PSM= MIME-Version: 1.0 Received: by 10.142.120.2 with SMTP id s2mr395160wfc.311.1259139047253; Wed, 25 Nov 2009 00:50:47 -0800 (PST) Date: Wed, 25 Nov 2009 14:20:47 +0530 Message-ID: <22b99aa10911250050p6cd2b06bl13616b47f00c94bc@mail.gmail.com> Subject: Regarding Stored Procedures From: Shazin Sadakath To: derby-dev@db.apache.org Content-Type: multipart/alternative; boundary=001636e0a80ca268a704792e2712 --001636e0a80ca268a704792e2712 Content-Type: text/plain; charset=ISO-8859-1 Hi All, Can anyone tell me what happens and what are the classes associated with below SQL Command send via a JDBC statement to Derby Engine. Statement 1 "CALL XXX()" Statement 2 "VALUES YYY()" XXX() is a Procedure YYY() is a Function Thanks in advance, Shazin --001636e0a80ca268a704792e2712 Content-Type: text/html; charset=ISO-8859-1 Hi All,

Can anyone tell me what happens and what are the classes associated with
below SQL Command send via a JDBC statement to Derby Engine.

Statement 1
"CALL XXX()"

Statement 2
"VALUES YYY()"

XXX() is a Procedure
YYY() is a Function

Thanks in advance,
Shazin
--001636e0a80ca268a704792e2712--