This week's book giveaway is in the Agile and Other Processes forum. We're giving away four copies of Real-World Software Development: A Project-Driven Guide to Fundamentals in Java and have Dr. Raoul-Gabriel Urma & Richard Warburton on-line! See this thread for details.
I searched couple of books and searched on net but couldn't find the syntax I'm looking for. Hope you guys can help. I'm calling a oracle proc in my java app. The proc returns a cursor. Can you please guide to how to define the IN OUT parameter. Thanks
[ January 25, 2006: Message edited by: Dilip kumar ]
In order to get the results from a stored procedure call, you must register any OUT or IN OUT parameters before executing the CallableStatement. To do this, call the CallableStatement object's registerOutParameter( ) method, passing it the position of the placeholder character in the callable-statement string starting at 1 and moving from left to right, just as you do for the other accessor methods, and a java.sql.Types constant to specify the SQL data type that will be returned. There are two applicable signatures for the registerOutParameter( ) method. For VARCHAR2 and DATE parameters, use the following signature: registerOutParameter( int parameterIndex, int sqlType) throws SQLException
(Java Programming with Oracle JDBC ISBN: 0-596-00088-x, 496 pages)
Computers are like air conditioners - They stop working properly when you open Windows
posted 14 years ago
Thanks for the response.
Looks like still something is wrong in my code. I'm getting error message PLS-00306: wrong number or types of arguments in call to getValues
I notice that your OUT param 'TYPE lineCurs IS REF CURSOR RETURN lineItemRec' is of type REF CURSOR. For Oracle, the param for registerOutParameter() is oracle.jdbc.driver.OracleTypes.CURSOR. Check the driver JAR file for the apt type code.
posted 14 years ago
It worked when I used csmt.registerOutParameter(14, OracleTypes.CURSOR);
A sonic boom would certainly ruin a giant souffle. But this tiny ad would protect it: