aspose file tools*
The moose likes JDBC and the fly likes Passing String array as out parameter to stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Passing String array as out parameter to stored procedure" Watch "Passing String array as out parameter to stored procedure" New topic
Author

Passing String array as out parameter to stored procedure

Ragupathirajan Venkatesan
Ranch Hand

Joined: Aug 18, 2010
Posts: 62
Dear All,

I am getting the ORA-06553: wrong number or types of arguments in call to 'Procedure' error when i am trying to pass the string array to oracle procedure.

I have created one oracle string array type like below.




then my oracle procedure ends.

The above proc got compiled and successfully. I am getting the exception while I am trying to execute it from java like below



Please suggest me, how should i pass the out parameter in the above java code.

Thanks in advance.
Sudheer Bhat
Ranch Hand

Joined: Feb 22, 2011
Posts: 75
You would need to change your code to
Ragupathirajan Venkatesan
Ranch Hand

Joined: Aug 18, 2010
Posts: 62
Thanks for your reply. Due to some technical requirements we dropped using the return string array in procedure. will use your ideas in future.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passing String array as out parameter to stored procedure