CURSOR report_cursor(v_namesearch VARCHAR2) IS
SELECT name, address
FROM emp WHERE name LIKE v_namesearch || '%';
Anything inside a quote is taken as a literal. Therefore, you cannot embed variables inside quotes.
Hope this helps,
- Chris
|
Results 1 to 6 of 6
Thread: CURSOR WITH PARAMETERThreaded View
|
Click Here to Expand Forum to Full Width |