Hi,
I am facing a typical problem in using sybase stored procedure from java
code. I am using DATA DIRECT type 4 jdbc driver for database connection.
Following is the detail:

We are getting some exception while trying register out parameter to
Sybase procedure from java code.
Please find the corresponding exception


Error while changing status:java.sql.SQLException:
[DataDirect][Sybase JDBC Driver][Sybase]Operand type clash: INT is
incompatible with VOID TYPE

I am using DATA DIRECT THPE 4 JDBC DRIVER. I there any restriction with
this driver.

Following is the java code:
cstmtUpdate=conn.prepareCall("{call
OPSals..pool_change_status(?,?,?,?,?)}");
cstmtUpdate.setInt(1,this.tipUnitNumber);
cstmtUpdate.setInt(2,Integer.parseInt(this.uni-
tStatus));
cstmtUpdate.setString(3,userId);
cstmtUpdate.registerOutParameter(4,
Types.INTEGER);
cstmtUpdate.registerOutParameter(5,
Types.VARCHAR);
cstmtUpdate.execute();


Please let me know if any of you got similar problem or are aware of
this.
Thnaks
Upinder..

--
usbali


Posted via http://dbforums.com