Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

calling pl/sql store proc with %rowtype arg

 
pascal monfils
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everybody,

I'm currently working on a java (1.4.2) project calling a Oracle9i db with pl/sql stored procedure.
One of the stored proc I need to call takes a <tablename>%ROWTYPE as argument. (the concerned table contains more than 100 fields ).

Does anyone know a method to call such a store procedure thru JDBC ?
( i.e. what type of Java objects maps the %rowtype of PL/SQL)

Thanks in advance for your light and help.

Pascal
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Pascal,

As far as I know you can't do it through the standard JDBC API. I would suggest checking out the documentation for your Oracle JDBC driver (ideally a native one) as it may provide extensions to access such Oracle-specific features.

Jules
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic