Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CallableStatement with TABLE type as OUT parameter

 
Dan Lastoria
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am creating a CallableStatement to execute an Oracle (9i) PL/SQL procedure. The out parameters of this procedure have been described to me as a TABLE type. I'm not sure how to process this within my Java code. I have hunted around a little bit, but I'm a little lost.

 
Gilbert johnson
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've used Table Types in Oracle but i have passed them to the stored procedure as an IN parameter from my java program.

You are trying to get the Table Types.

Try this. I'm not sure though:

stmt.registerOutParameter( 1, OracleTypes.ARRAY,"TABLENAME" );

// The name TABLENAME, has to match the name of the table type defined in the PL/SQL Stored Function
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic