posted 16 years ago
Hi,
I am calling a sybase SP from my application like following:
conn = getSybaseConnection();
procName = " testschema.PlaceOrder";
procStmt = "{?=CALL " + procName + "( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}";
I am setting all other variables and also do like this.
cstmt.setString(2, address);
.....
cstmt.registerOutParameter(1, Types.INTEGER);
cstmt.registerOutParameter(44, Types.INTEGER);
cstmt.registerOutParameter(45, Types.INTEGER);
First '?' and last 2 '?' are out parameters.
But, after execution, I am getting the following error:
"Operand type clash: INT is incompatible with DATETIME"
when I try to access my first out param as:
cstmt.execute();
procStatus = cstmt.getInt(1);
Could someone tell what would be the problem?
Thanks in advance,
Raj A