Re: Error in Stored Procedure [message #36753] |
Mon, 17 December 2001 07:49 |
Poonamb
Messages: 16 Registered: October 2001
|
Junior Member |
|
|
Hello,
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!
PB
----------------------------------------------------------------------
|
|
|