Thread: CallableStatement implementation

CallableStatement implementation

From
"Scott Gammill"
Date:
We're working on an implementation of CallableStatement.

Here is how we see it:
CallableStatement only supports IN parameters and one OUT parameter which is
the return value (or ResultSet) of the function.  If the user tries to register
an OUT parameter other than parameter 1, then an exception is thrown.

This is directly supported by the way postgresql does stored procedures.
Postgresql does not support function parameters being OUT parameters, as far as
we know.  (Correct me if this is wrong.)

We could also try to support some extensions to the JDBC spec. for
CallableStatement.  For example, we could try to allow a callable statement to
retrieve columns of data from tables created by the stored procedure.  Please
give some feedback as to whether or not this feature would be useful/wanted.
We welcome other ideas for extensions as well.

Scott Gammill



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com