File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid number error

 
Gireesh Mulage
Ranch Hand
Posts: 44
  • 0
  • 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
  • 0
  • 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