Home » SQL & PL/SQL » SQL & PL/SQL » Re: Error in Stored Procedure
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;

----------------------------------------------------------------------
Previous Topic: move a tablespace of table
Next Topic: Can I call a Package Function from Oracle in VC++ with ADO ?
Goto Forum:
  


Current Time: Mon Apr 06 01:23:31 CDT 2020