Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help : PL/SQL Cursor Limitations
/* Cursor Declaration */
Cursor Employee is
select Emp_Name
from Employee
where Emp_id in (:global.string);
/* Explanation */
:global.string := '12,23,54,65' ;
I am trying to use IN operator to compare
Emp_id against a set of values. This query Treates the set
(:global.string)
as a single value and returns nothing.
If I initialize :global.string := '12' then the query runs fine.
What's the Problem with this Cursor Declaration ? by the way I am working in Forms 4.5
Thanks in advance. Received on Tue Jul 22 1997 - 00:00:00 CDT