Cursor Parameter List
boffmanAug 11 2008 — edited Aug 13 2008Hi,
recently I found out that a cursor must not have explicit a defined parameter list:
1. Option
cursor cur_example
is
select name
from table1
where name = p_name
;
=> instead of
2. Option
cursor cur_example (p_name IN VARCHAR2)
is
select name
from table1
where name = p_name
;
why is then sometimes a parameterlist definition necessary?
cheers,
Bernhard