File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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
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
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

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
JDBC, Stored Procedure and Rowtype
How to pass a ROWTYPE parameter to an Oracle Stored Procedure?
VARBINARY in sp -how-to
%rowtype mapping in java
Parameter types