aspose 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: 26
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: 26
Interesting, just standard columns, no BLOB or CLOB, but it definitely does not like it. Thanks, I will keep testing.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Correct way to pass cursor record to procedure