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
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

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


Current Time: Thu Mar 28 15:51:35 CDT 2024