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)
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.
subject: calling pl/sql store proc with %rowtype arg