aspose file tools
The moose likes JDBC and the fly likes oracle pl/sql stored proc and %rowtype with jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "oracle pl/sql stored proc and %rowtype with jdbc" Watch "oracle pl/sql stored proc and %rowtype with jdbc" New topic
Author

oracle pl/sql stored proc and %rowtype with jdbc

Shawn Garner
Greenhorn

Joined: Aug 25, 2005
Posts: 17
posted private message
0
Quote
I want to declare my stored procedures as having an input parameter of type a row of a table.

For example user_table%rowtype.

I've been trying to use a STRUCT.
I get a "Fail to construct descriptor: Invalid arguments" message.

My java class implements the SQLData interface.

Any help?
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: oracle pl/sql stored proc and %rowtype with jdbc
 
Similar Threads
calling pl/sql store proc with %rowtype arg
How to pass a ROWTYPE parameter to an Oracle Stored Procedure?
%rowtype mapping in java
RowType in Java???
JDBC, Stored Procedure and Rowtype