aspose file tools*
The moose likes JDBC and the fly likes calling pl/sql store proc with %rowtype arg Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "calling pl/sql store proc with %rowtype arg" Watch "calling pl/sql store proc with %rowtype arg" New topic
Author

calling pl/sql store proc with %rowtype arg

pascal monfils
Greenhorn

Joined: Aug 09, 2004
Posts: 9
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

Joined: Aug 02, 2004
Posts: 823
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
 
 
subject: calling pl/sql store proc with %rowtype arg