How to pass string as a parameter to the cursor
528801Sep 11 2007 — edited Sep 11 2007Hi,
I have one issue with cursor. Anybody could pls tell me how to pass string to the cursor as a parameter, that needs to be concat with select statement in the cursor.
Eg:
cursor cur1(lstr varchar) is
select col1, col2, from table1 ||' '||lstr;
pls assume lstr may be like this where col1='BR1'
Thanks in advance...
Mahi