This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma 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