PL/SQL (MOSC)

MOSC Banner

passing a variable within in stored a procedure

edited Jul 1, 2013 6:01AM in PL/SQL (MOSC) 1 commentAnswered ✓
This is an example of my question..  When I format my LIKE clause (see below) ... it doesn't bring back anything because it is looking for the word    var1

create or replace s_proc (var1 in varchar2) as

cursor c1 is

select column1, column2

from table1

where column1 like('%var1%')   >>>> how do I format this where clause with a like statement ??? 

;

rec1    c1%rowtype;

begin

whatver ...

end

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center