Re: Help : PL/SQL Cursor Limitations

Hi there,

I think you should use dynamic cursor (prepare, open and fetch) to access multiple values. Your code will work only for a single value.

Regards

N.Prabhakar

Venu Ellendula <vellendu_at_pt5026.pto.ford.com> wrote in article <33D4B22A.7331_at_pt5026.pto.ford.com>...
> /* 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 Thu Jul 31 1997 - 00:00:00 CEST