Calling PL/SQL from Java
September 24, 2010
I had a need to call a PL/SQL procedure from Java, where it took one input parameter and returned six output parameters.
This is done by creating a CallableStatement instead of the normal PreparedStatement, and then you need to register each output parameter before calling execute().
String lExecuteSql = "{call …
