This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
Dear all, I've got a Pl/Sql stored procedure declared as: add_address(first_name in varchar2, last_name in varchar2) is begin .... end; I'm trying to call it from within java: ... CallableStatement storedProc = con.prepareCall("begin add_address(?,?); end;"); storedProc.setString(1,"AAAA"); storedProc.setString(2,"BBBB"); storedProc.execute(); .... The following exception is being thrown: java.Sql.SQLException:[Oracle][ODBC Oracle Driver][Oracle OCI] ORA-00900: Invalid SQL statement.
Could anybody please point me in the right direction? Thanks in advance Ambrose Tati