• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Balaji Munuswamy
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
Use CallableStatement for executing
procedure
regards
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic