Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help : PL/SQL Cursor Limitations
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 CDT