From derby-user-return-2166-apmail-db-derby-user-archive=db.apache.org@db.apache.org Sun Oct 02 22:51:33 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 8220 invoked from network); 2 Oct 2005 22:51:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Oct 2005 22:51:32 -0000 Received: (qmail 94399 invoked by uid 500); 2 Oct 2005 22:51:31 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 94372 invoked by uid 500); 2 Oct 2005 22:51: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 94360 invoked by uid 99); 2 Oct 2005 22:51:31 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Oct 2005 15:51:31 -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 [216.148.227.117] (HELO rwcrmhc11.comcast.net) (216.148.227.117) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Oct 2005 15:51:34 -0700 Received: from [127.0.0.1] (pcp0011932243pcs.summit01.nj.comcast.net[69.249.77.51]) by comcast.net (rwcrmhc11) with ESMTP id <20051002225104013003q467e>; Sun, 2 Oct 2005 22:51:05 +0000 Message-ID: <4340644E.4030107@neometsys.fr> Date: Sun, 02 Oct 2005 18:50:54 -0400 From: Nicolas Dufour User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Argg stored procedures ! Content-Type: text/plain; charset=ISO-8859-1; format=flowed 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 Hi Still working on my porting an SQL Server database to a derby one, I have some questions for you. Before, thanks to Army for the function creation. I have read the IBM forum about derby stored procedure and I have created one which works prefectly in ij but i cant call the procedure from an ODBC link !? I just put : CALL ALTTIME2(1) And the link said : wrong syntax ! Like it doesnt understand everuthing including the word 'CALL' ! Ok .. thanks odbc .. it helps a lot... if you have any idea about this one. Another question about stored procedure : I want to create a stored procedure which the goal will be to do a select with a 'where in ' and a list of integer. This list of integer should be the parameter of my stored procedure, but how can i do that ? or perhaps its not the right way to do it ? Thank you a lot Nicolas