File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
How to Pass %ROWTYPE as Input parameter for a Procedure?
Joined: Apr 07, 2002
Aug 08, 2002 03:34:00
I have a Procedure which accept rowtype as Input.
How to Execute the Procedure using
PROCEDURE PROC_JOB_INSERT(l_rec job%ROWTYPE) IS
Joined: Jul 25, 2001
Aug 08, 2002 04:48:00
Use CallableStatement for executing
Want to do something great will do one day
Joined: Jul 09, 2001
Aug 08, 2002 07:15:00
here is a link to Oracle's
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
[ August 08, 2002: Message edited by: Jamie Robertson ]
I agree. Here's the link:
subject: How to Pass %ROWTYPE as Input parameter for a Procedure?
JDBC, Stored Procedure and Rowtype
How to pass a ROWTYPE parameter to an Oracle Stored Procedure?
%rowtype mapping in java
VARBINARY in sp -how-to
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015