like verb in cursor in pl/sql

From: Andrew M.Yonce <ayonce_at_mindspring.com>
Date: Wed, 26 Aug 1998 03:16:43 GMT
Message-ID: <35e37ba2.560901@news.mindspring.com>

Does anyone know if it is possible to use LIKE as part of cursor in pl/sql. For example

Cursor employer_list(namein IN varchar2) IS Select employer_name FROM employer
Where employer_name like namein;
empname varchar2(50) default 'GE';
BEGIN
namein := ''''||'%'||empname||'%'||''''; FOR el in employer_list
LOOP
.........
END LOOP;

---

The above statements do return any rows, nor does exception of any kind get raised.

Anyone have a solution? Received on Tue Aug 25 1998 - 22:16:43 CDT