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