Re: HELP....CURSORS
From: <surya_at_usa.net>
Date: 1995/05/16
Message-ID: <3paddi$l80_at_earth.usa.net>#1/1
end temp;
Date: 1995/05/16
Message-ID: <3paddi$l80_at_earth.usa.net>#1/1
> ahsan_at_wraith.cs.uow.edu.au (Ahsan Jalil) writes:
>
> Iam having trouble in using cursors i.e how to define two cursors one after
> the other in a PL/SQL procedure. What iam trying to do is
Try:
create procedure temp(....) as
...
begin
declare
cursor a is select...from....where... begin
for var in a loop (statements) end loop
end
declare
cursor b is select... from.... where... begin
for var in b loop (statements) end loop
end
end temp;
or
create procedure temp(....) as
...
cursor a is select...from....where...
cursor b is select... from.... where...
begin
for var in a loop (statements) end loop
for var in b loop (statements) end loop
end
end temp;
Ganesh Puranik, Surya Systems, Inc. Received on Tue May 16 1995 - 00:00:00 CEST