Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: cursor problem.
Try redefining your cursor ("rad") as a parametrized cursor, so that you explicitely pass it the value provided as argument to your procedure.
Using a parametrized cursor your code should look something like:
create or replace procedure show (grom in varchar2) is
cursor rad ( MY_GROM VARCHAR2 ) is select * from Rom where Type= MY_GROM and Stoerrelse>=6 and Stoerrelse<=15; r rad%rowtype; begin open rad(GROM); fetch rad into r; htp.print