aspose file tools
The moose likes JDBC and the fly likes How to Pass %ROWTYPE as Input parameter for a Procedure? 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 "How to Pass %ROWTYPE as Input parameter for a Procedure?" Watch "How to Pass %ROWTYPE as Input parameter for a Procedure?" New topic
Author

How to Pass %ROWTYPE as Input parameter for a Procedure?

Balaji Munuswamy
Ranch Hand

Joined: Apr 07, 2002
Posts: 37
posted private message
0
Quote
Hi All..
I have a Procedure which accept rowtype as Input.
How to Execute the Procedure using java Code?

PROCEDURE PROC_JOB_INSERT(l_rec job%ROWTYPE) IS
BEGIN
....
...
End
Tks
Balaji.M
sandeep balyan
Ranch Hand

Joined: Jul 25, 2001
Posts: 134
posted
0
Quote
hi
Use CallableStatement for executing
procedure
regards

Want to do something great will do one day
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

I like...
MySQL Database Suse
posted private message
0
Quote
here is a link to Oracle's JDBC --> stored procedure code. I'm pretty sure that JDBC does not support ROWTYPES. I'm sure you can modify the procedure and work around it though.j
Jamie
[ August 08, 2002: Message edited by: Jamie Robertson ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to Pass %ROWTYPE as Input parameter for a Procedure?
 
Similar Threads
How to pass a ROWTYPE parameter to an Oracle Stored Procedure?
%rowtype mapping in java
JDBC, Stored Procedure and Rowtype
Parameter types
VARBINARY in sp -how-to