Re: Help : PL/SQL Cursor Limitations

[Quoted] I'm coming into this late, without the original posting in front of me, but I [Quoted] believe the following will work in this case.

select Emp_Name
from Employee
where decode(sign(instr(:global.string,ltrim(to_char(Emp_id,'09')))),1,Emp_id,0) = Emp_id;

Regards,

Phil

In article <33D5C41C.7723_at_Singapore.Sun.com>, Manivannan <Manivannan.Paramasivam_at_Singapore.Sun.com> says:
#
#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' ;
##
## 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 24 1997 - 00:00:00 CEST