Re: cursor problem.

Vegard Tollefsen wrote:
>
> 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 -----------------------------------------------/--\/----\-----
So what way *does* it work? Or doesn't it work at all? What is the problem?

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