posted 18 years ago
I am calling a stored procedure in an oracle database.
It is executing properly but I am getting a problem in getting back the data.
Here is what I have:
CallableStatement cstmt = conn.prepareCall("{? = call device_search.qipep(?)}");
cstmt.registerOutParameter(1,OracleTypes.CURSOR);
cstmt.setString(2,ip_address);
cstmt.execute();
//When it reaches here an ORA-00900: invalid SQL statement is thrown.
ResultSet rs = (ResultSet)cstmt.getObject(1);
I think this problem could because of datatype mismatch.
Is there any other way of retrieving data from stored procedure.
Please help