db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oystein Grovlen - Sun Norway <Oystein.Grov...@Sun.COM>
Subject Re: Procedure return value
Date Mon, 16 Jul 2007 15:47:39 GMT
Jacques Coetzee wrote:
> 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.

I am probably missing something, but can you not let the status-code be 
an INOUT parameter?

-- 
Øystein

Mime
View raw message