• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid number error

 
Gireesh Mulage
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic