Re: Help : PL/SQL Cursor Limitations

[Quoted] Venu Ellendula wrote:
>
> /* Cursor Declaration */
>
> Cursor Employee is
> select Emp_Name
> from Employee
> where Emp_id in (:global.string);
>
> /* Explanation */
>
> :global.string := '12,23,54,65' ;
 

> What's the Problem with this Cursor Declaration ?
> by the way I am working in Forms 4.5

Hmm. Tricky one this. The only way I got it to work was :

:global.str1 := 12;
:global.str2 := 23;
.
.
etc.

Then

 Cursor Employee is

     select Emp_Name
      from Employee
     where Emp_id in (:global.str1, :global.str2,...etc.);

Something to do with Globals ? Anybody else with a suggestion ?

NLS Received on Wed Jul 23 1997 - 00:00:00 CEST