Re: CURSORS IN STORED PROCEDURE

In article <vinodb-0709951536010001_at_bidark_mac.sdt.com>, vinodb_at_sdt.com (Vinod Bidarkoppa) writes:
|> Is it OK to have a DECLARE section in a Oracle stored procedure ?
|> Ex.
|> Create procedure try () as
|>
|> declare
|>
|> var...
|> begin
|>
|> .....
|> declare
|> var
|>
|> begin
|>
|> end
|> end try
|>
|>
|> Can we open nested cursors in a procedure ?
|>
|> Thanks in advance.
|>
|>
|> Vinod
|>
|> email: vinodb_at_sdt.com
Yes, but you don't use the keyword 'declare': create procedure try as
  var...
  cursor c is ...
begin
  open c;
  ...
end try; Received on Thu Sep 07 1995 - 00:00:00 CEST