From derby-user-return-2124-apmail-db-derby-user-archive=db.apache.org@db.apache.org Mon Sep 26 15:54:33 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 55789 invoked from network); 26 Sep 2005 15:54:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 26 Sep 2005 15:54:33 -0000 Received: (qmail 64042 invoked by uid 500); 26 Sep 2005 15:54:31 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 64014 invoked by uid 500); 26 Sep 2005 15:54:31 -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 63997 invoked by uid 99); 26 Sep 2005 15:54:31 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Sep 2005 08:54:31 -0700 X-ASF-Spam-Status: No, hits=0.8 required=10.0 tests=DNS_FROM_RFC_ABUSE,NO_REAL_NAME,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [194.7.80.34] (HELO INTL_EROC07.hqintl1.com) (194.7.80.34) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Sep 2005 08:54:37 -0700 Subject: RE: cant' get user defined function to work Date: Mon, 26 Sep 2005 17:54:14 +0200 MIME-Version: 1.0 To: derby-user@db.apache.org Cc: From: Erik.Bengtson@intl.westernunion.com X-Mailer: Microsoft Outlook v 10.00.6626, MSOC v 2.00.4007.00 Message-ID: X-MIMETrack: Serialize by Router on ErocNotes2/EROC/International(Release 5.0.13a |April 8, 2004) at 09/26/2005 05:54:29 PM, Serialize complete at 09/26/2005 05:54:29 PM Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Deepa, >If you define a function using 'CREATE FUNCTION ...' and call it using >CALL {function} statement, you get the same error as above. To call a >function in Derby, either VALUES or SELECT has to be used. >e.g: VALUES JPOX_ASCII('a'); I use SELECT 1 FROM TABLE WHERE JPOX_ASCII('a') = 55 Regards, Erik Bengtson RE