• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
Bartenders:
  • Himai Minh
  • Carey Brown
  • Frits Walraven

Registering IN OUT parameter

 
Ranch Hand
Posts: 360
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All -

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 ]
 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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)
 
Dilip kumar
Ranch Hand
Posts: 360
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

 
Ranch Hand
Posts: 106
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Dilip kumar
Ranch Hand
Posts: 360
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks much.

It worked when I used
csmt.registerOutParameter(14, OracleTypes.CURSOR);
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic