cursor problem.

From: Vegard Tollefsen <vegard_at_hinux.hin.no>
Date: 1997/03/13
Message-ID: <Pine.LNX.3.96.970313221100.11503A-100000@hinux.hin.no>#1/1

When I call the procedure 'show' I also want to send in an argument 'grom'.
I want to use that argument when I define a cursor. Like this:

create or replace procedure show (grom in varchar2) is

cursor rad is 	select * from Rom
		where Type=grom
		and Stoerrelse>=6
		and Stoerrelse<=15;

r rad%rowtype;
begin
open rad;
fetch rad into r;
htp.print
(r.Romnummer||r.Stoerrelse||r.Blokk||r.Etasje||r.Type||r.Status); end
/

But this dont work the way it should. Why?? Thanks.

• Vegard Tollefsen ----------------------------------\--\------/----
• Elgveien 13 ------ E-mail: vegard_at_hinux.hin.no -----\/-\----/\-----
• 8500 Narvik ------ http://hinux.hin.no/~vegard ------\-/\--/--\-----
• NORWAY -----------------------------------------------/--\/----\-----

Received on Thu Mar 13 1997 - 00:00:00 CST