Invalid number error

[Gireesh Mulage]

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]

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

  

  sql_str  :=  ' SELECT whatever FROM whatever_table  WHERE some_col IN ('  || your_string_of_numbers  || ')' ;
  EXECUTE IMMEDIATE  sql_str;