Operator usage - help [message #23138] |
Tue, 19 November 2002 15:34 |
Senthil
Messages: 68 Registered: December 1999
|
Member |
|
|
IN Operator - Help please
Following Sql works for me,
Select
*
From
Table where ID in (1,2,3,4,5)
If i use the above statement in stored procedure like this
varIDs := '1,2,3,4,5';
open cursorTable
as
Select
*
From
Table where ID in (varIDS)
I got 'ora-01722: Invalid number'.
so i changed the where condition to to_char(ID) in (varIDS), it returns zero record. I dont know how to implement this, can you please help me. I am using package & i call the package from vb component.
Thanks in advance
|
|
|
|