db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Coetzee (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2927) Procedures can't return values other than ResultSets
Date Thu, 12 Jul 2007 09:42:04 GMT
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
             Fix For: 10.0.2.2


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.


Mime
View raw message