Re: CURSORS IN STORED PROCEDURE
From: <mmelanco_at_sfi-software.com>
Date: 1995/09/08
Message-ID: <42pekf$lce_at_romulus.ott.hookup.net>#1/1
Date: 1995/09/08
Message-ID: <42pekf$lce_at_romulus.ott.hookup.net>#1/1
> 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
>
>>>>
There is no such thing as nesting cursor declaration, but you can declare more the one cusror in the same procedure no problem
Marc, Hope this helps.
Received on Fri Sep 08 1995 - 00:00:00 CEST