Help : PL/SQL Cursor Limitations
From: Venu Ellendula <vellendu_at_pt5026.pto.ford.com>
Date: 1997/07/22
Message-ID: <33D4B22A.7331_at_pt5026.pto.ford.com>#1/1
Date: 1997/07/22
Message-ID: <33D4B22A.7331_at_pt5026.pto.ford.com>#1/1
/* Cursor Declaration */
Cursor Employee is
select Emp_Name
from Employee
[Quoted] where Emp_id in (:global.string);
/* Explanation */
[Quoted] :global.string := '12,23,54,65' ;
[Quoted] [Quoted] 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.
[Quoted] If I initialize :global.string := '12' then the query runs fine.
[Quoted] 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 CEST