File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Correct way to pass cursor record to procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Correct way to pass cursor record to procedure" Watch "Correct way to pass cursor record to procedure" New topic
Author

Correct way to pass cursor record to procedure

Scott Halepaska
Greenhorn

Joined: Dec 26, 2006
Posts: 25
Using Oracle 10g, I have the following defined:



But I get Error 00306: wrong number or types of arguments in call to 'CREATE_APPLICANT' when I call the procedure as defined below:



Can someone point me in the right direction for passing a cursor record to a procedure?
Gene Hilpert
Ranch Hand

Joined: May 22, 2002
Posts: 51

Do you have any BLOBs or CLOBs in you table, sometime that will mess thing up.
I did try a test and it worked for me.
Scott Halepaska
Greenhorn

Joined: Dec 26, 2006
Posts: 25
Interesting, just standard columns, no BLOB or CLOB, but it definitely does not like it. Thanks, I will keep testing.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Correct way to pass cursor record to procedure
 
Similar Threads
Pass cursor iteration as parameter to PL/SQL procedure or function
Error in jdbc while executing procedure
retrieve rows
pl sql related problem
How to Pass %ROWTYPE as Input parameter for a Procedure?