Originally posted by KASI VISHWANATH:
Can u explain what errors are u getting in detail
Dear Kasi,
I've recently downloaded Oracle73 Version 2.05.0301 ODBC driver.
Installed ok and runs ok, but I get runtime exceptions when calling PL/SQL
stored procedures with parameters. Also can't use any new
features in the JDBC 2.0 API. Doesn't this Oracle ODBC driver version support what I'm trying to do? Can anybody please help?
I'm using Java 1.3/Personal Oracle 7/Windows98
For example this call to my stored procedure add_address, which takes two IN parameters
...
CallableStatement storedProc =
con.prepareCall("{call add_address(?,?)}");
storedProc.setString(1,"AAAA");
storedProc.setString(2,"BBBB");
storedProc.execute();
...
Throws the following exception:
java.Sql.SQLException:[Oracle][ODBC Oracle Driver][Oracle OCI] ORA-00900: Invalid SQL statement.
Thanks
Ambrose