You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Holger Rehn (JIRA)" <ji...@apache.org> on 2012/10/11 19:51:35 UTC
[jira] [Commented] (DERBY-2927) Procedures can't return values
other than ResultSets
[ https://issues.apache.org/jira/browse/DERBY-2927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13474368#comment-13474368 ]
Holger Rehn commented on DERBY-2927:
------------------------------------
+1
For me it looks like this is allowed by the SQL standard. At least the German book "Einführung in den Sprachkern von SQL-99" ("Introduction to the core of the SQL-99 language") mentions a return value of procedures (and as pointed out, the JDBC specs explicitly allow procedure calls in the form {?=call procedure(? ...)}). And at least Sybase, Microsoft and IBM allow that in their products, so why shouldn't it be allowed in Derby?
Cheers,
momo
> 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
> Labels: derby_triage10_10
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira