I'm wondering if anyone can tell me why this does not work:
cursor SONGS (scol varchar2, searchval varchar2) is
select * from ss1 where scol like searchval ;
if I call SONGS with the column name specified, it won't work; it works
with searchval.
What are the appropriate work-arounds? Obviously, I'd like to have a
single cursor defined which allows me to specify both the search text as
well as the column to search on.
Please e-mail: rburton_at_rohms.com Thanks!