Java object as parameter to Java stored procedure

Thread view:

kastis - 29 Jul 2004 15:55 GMT

What are the steps required to do to pass user defined class object as
the parameter(IN or OUT) to java stored procedure, that class was
uploaded into schema.

thanks

Reply to this Message

Lee Fesperman - 30 Jul 2004 03:11 GMT

> What are the steps required to do to pass user defined class object as
> the parameter(IN or OUT) to java stored procedure, that class was
> uploaded into schema.

You neglected to mention the DBMS you're using, but the general way is to use
setObject() for IN parameters and registerOutParameter() and getObject() for OUT
parameters. Here's an example for an IN/OUT parameter:

MyObject myObj = new MyObject(1234);
CallableStatement call = conn.prepareCall("{call my_sp(?)}");
call.registerOutParameter(1, Types.OTHER); // register as OUT parameter
call.setObject(1, myObj); // set IN parameter
call.execute(); // do call
MyObject myResult = (MyObject) call.getObject(1); // get resulting OUT parameter

Signature

Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

Java object as parameter to Java stored procedure

Free Magazines