This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Passing an array of integers to stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Passing an array of integers to stored procedure" Watch "Passing an array of integers to stored procedure" New topic
Author

Passing an array of integers to stored procedure

Gireesh Mulage
Ranch Hand

Joined: Mar 08, 2010
Posts: 44
HI All ,


I am facing a problem while writing a procedure .... please help me on this ....

I have to pass the parameter of type varchar2 to procedure . The parameter can have value like 1,2,3 .
Using that parameter i have to get some values from one table say 'select id from YY where XX in (input parameter);' I am getting ORA-01722 and ORA-06512 errors while execting the procedure . We are using Oracle 10 G .


How do i split the values ?

Thanks
Gireesh Mulage
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
What type is XX? If XX is a number and your input parameter is a VARCHAR that would be your problem.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Passing an array of integers to stored procedure
 
Similar Threads
Oracle ORA-29902 Error!
java.sql.SQLException: Pls Help
Passing an array of integers to stored procedure
Passing String array as out parameter to stored procedure
java ORA-06550 PLS-00801