Re: Error in Stored Procedure [message #36750] |
Mon, 17 December 2001 07:40 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
Change cursor stmt like below ( use all single quotes, not double quotes)
Procedure sp_acs_gallery_getusers(v_alphabet in varchar2, io_cursor out t_cursor)
is begin
open io_cursor for
'Select * from users where status <> 0 and upper(firstname) like ' ||''''||'%' || upper(v_alphabet) ||'%'||'''';
end sp_acs_gallery_getusers;
----------------------------------------------------------------------
|
|
|