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


/* 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

Original text of this message