Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <15354816.1195237543322.JavaMail.jira@brutus>
Date: Fri, 16 Nov 2007 10:25:43 -0800 (PST)
From: "Daniel John Debrunner (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Issue Comment Edited: (DERBY-2927) Procedures can't return
 values other than ResultSets
In-Reply-To: <19328105.1184233324442.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-2927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543155 ] 

djd edited comment on DERBY-2927 at 11/16/07 10:23 AM:
-------------------------------------------------------------------------

Not sure if such procedures are allowed by the SQL standard.

JDBC does support an escape sequence:

{ ? = call procedure(params) }

but not sure it maps to anything in the SQL standard.

      was (Author: djd):
    Not sure if such procedures are allowed by the SQL standard.

JDBC does support an escape sequence:

? = call procedure(params)

but not sure it maps to anything in the SQL standard.
  
> Procedures can't return values other than ResultSets
> ----------------------------------------------------
>
>                 Key: DERBY-2927
>                 URL: https://issues.apache.org/jira/browse/DERBY-2927
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.2.2.0
>         Environment: Java 1.4.2
> Windows XP SP 2
>            Reporter: Jacques Coetzee
>
> First off, this is not really a bug, it's more of a restriction.
>  
> As per the needs of my inhouse framework I need a procedure to be able to return a value other than
> a ResultSet (I need a integer). The reason I need to use a procedure; is because I'm using INOUT parameters.
>  
> When call my procedure, it needs to look like this:
>  
> { ? = call myProcedure(?,?,?,?,?,?)}
>  
> Where the first ? represents a status-code, ie a failure = -1, and a successfull would be 1.
> All the other procedure paramters are INOUT.
>  
> If I where to use normal scripting methods in any other DB, for instance DB2 or Oracle
> then I would be able to do this. It seems that the problem has to do with using
> JAVA "Stored" Procedures.
>  
> Is it possible to either make procedures return primitive types, OR
> for Functions to be able to use OUT and INOUT paramters?
>  
> I've got High Hopes for Derby, but it's issues like this that might just
> sway me to use a different DB.
>  
> I appreciate any feedback you can give me.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.