aspose file tools*
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
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passing an array of integers to stored procedure