Home » SQL & PL/SQL » SQL & PL/SQL » Re: Error in Stored Procedure
Re: Error in Stored Procedure [message #36753] Mon, 17 December 2001 07:49
Messages: 16
Registered: October 2001
Junior Member

This is the search condition that will work.

UPPER(first_name) like (UPPER(v_alphabet) || '%')

-- You need not have two conditions to check.
-- You are using %A% which will result in all names which have A in it. You need to do A% only to derive all names that begin with A or any other alphabet.
-- you need to define t_cursor as a ref_cursor as well (I guess you are doing that).
-- use a single quote to reference text values, not double quotes.

Hope this helps!

Previous Topic: Executing a Host command from PL/SQL procedure
Next Topic: .nextval in Insert Statement
Goto Forum:

Current Time: Sat May 18 21:13:32 CDT 2024