From derby-user-return-3971-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Apr 05 00:48:03 2006 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 80710 invoked from network); 5 Apr 2006 00:48:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Apr 2006 00:48:03 -0000 Received: (qmail 6211 invoked by uid 500); 5 Apr 2006 00:48:02 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 6187 invoked by uid 500); 5 Apr 2006 00:48:02 -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 6176 invoked by uid 99); 5 Apr 2006 00:48:02 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Apr 2006 17:48:02 -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 [32.97.110.154] (HELO e36.co.us.ibm.com) (32.97.110.154) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Apr 2006 17:48:01 -0700 Received: from d03relay04.boulder.ibm.com (d03relay04.boulder.ibm.com [9.17.195.106]) by e36.co.us.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id k350leWb019035 for ; Tue, 4 Apr 2006 20:47:40 -0400 Received: from d03av04.boulder.ibm.com (d03av04.boulder.ibm.com [9.17.195.170]) by d03relay04.boulder.ibm.com (8.12.10/NCO/VER6.8) with ESMTP id k350oqWY185666 for ; Tue, 4 Apr 2006 18:50:52 -0600 Received: from d03av04.boulder.ibm.com (loopback [127.0.0.1]) by d03av04.boulder.ibm.com (8.12.11/8.13.3) with ESMTP id k350lei4004453 for ; Tue, 4 Apr 2006 18:47:40 -0600 Received: from [127.0.0.1] (sig-9-48-122-98.mts.ibm.com [9.48.122.98]) by d03av04.boulder.ibm.com (8.12.11/8.12.11) with ESMTP id k350lcoF004365 for ; Tue, 4 Apr 2006 18:47:39 -0600 Message-ID: <4433136E.5090901@apache.org> Date: Tue, 04 Apr 2006 17:46:38 -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: unable to execute procedure References: <3535996c0604032059j52de8f50s7073f167d816e9d2@mail.gmail.com> <3535996c0604041400j3c72e495t569472ea3fbaac1d@mail.gmail.com> <4433057A.2030902@gmail.com> <3535996c0604041739i3012a2e8o634a1cd31d328532@mail.gmail.com> In-Reply-To: <3535996c0604041739i3012a2e8o634a1cd31d328532@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 Anil Samuel wrote: > Thanks all for the pros/cons of PreparedStatement; That code snippet was > only *meant* to depict the problem I had with the procedure call and no way > a coding practise !! > > Ok. I tried this and still no different; below is the result > ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.classpath',' > dtp.LeaveApp_jar'); > 0 rows inserted/updated/deleted > ij> CALL dtp.TOTAL_LEAVE_FOR_TYPE('TOM',3); > ERROR 42Y03: 'DTP.TOTAL_LEAVE_FOR_TYPE' is not recognized as a function or > procedure. So you can't use CALL for a function. I sent the examples of a function use earlier, using the VALUES or SELECT statements. Dan.