Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: cursor problem.

Re: cursor problem.

From: Ricardo Rocha <rrocha_at_usagate.net>
Date: 1997/03/15
Message-ID: <01bc310c$d0a95c60$6564c7d0@rrocha>#1/1

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

(r.Romnummer||r.Stoerrelse||r.Blokk||r.Etasje||r.Type||r.Status); end;
/ Received on Sat Mar 15 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US