This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Invalid number error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Invalid number error" Watch "Invalid number error" New topic

Invalid number error

Gireesh Mulage
Ranch Hand

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

To my stored procedure , i need to pass some numbers which can be used in the IN clause of select query of a cursor.
For this i had created a type and a function to get the array . Using that array , i have tried to put in a variable of type varchar.
I have used that new variable in the IN clause of the select query of a cursor. I am getting ORA-01722 error.

is there any other way to get to this ?

Please help me on this.
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
I think you may have to use NDS to do this. You could use your concatenated list
of numbers in your in clause . Something like this

Don't get me started about those stupid light bulbs.
subject: Invalid number error