Re: Is this legal?

Lol, ok, you get an award for that response.

Seriously, don't be afraid to test, it would have been faster to test that out than post the question.

On Mar 1, 7:57 pm, "Anurag Varma" <avora..._at_gmail.com> wrote:
> On Mar 1, 8:36 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
>
>
>
>
>
> > I know in a package I could have something similar to:
>
> > PROCEDURE procedure_name
> > IS
>
> > PROCEDURE local_procedure
> > IS
> > BEGIN
> > ...
> > END;
>
> > BEGIN
>
> > body of procedure ...
>
> > END;
>
> > My question is can the same thing be done inside an anonymous block within a
> > script file like:
>
> > DECLARE
>
> > PROCEDURE local_procedure
> > IS
> > BEGIN
> > ...
> > END;
>
> > BEGIN
> > ...
> > END;
>
> > Thanks.
>
> Go on .. test it. You know, you've got to take risks sometimes:
>
> ORA92> declare
> 2 procedure local_procedure
> 3 is
> 4 begin
> 5 dbms_output.put_line('Yes its friggin legal');
> 6 end;
> 7 begin
> 8 local_procedure;
> 9 end;
> 10 /
> Yes its friggin legal
>
> PL/SQL procedure successfully completed.
>
> Anurag- Hide quoted text -
>
> - Show quoted text -
Received on Fri Mar 02 2007 - 07:32:28 CST