• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Passing String array as out parameter to stored procedure

 
Ragupathirajan Venkatesan
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You would need to change your code to
 
Ragupathirajan Venkatesan
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply. Due to some technical requirements we dropped using the return string array in procedure. will use your ideas in future.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic