aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
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
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Hi Gireesh,

You can pass the array as a string parameter then parse it into numbers to form an array.
Then you may continue with a loop or execute immediate.

Or as an alternative take a look at what Tom says.

Regards,

Fatih.
Gireesh Mulage
Ranch Hand

Joined: Mar 08, 2010
Posts: 44
Thanks Fatih ,

It worked .
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passing an array of integers to stored procedure