Re: Is this legal?

On Mar 2, 8:32 am, "mfuller..._at_gmail.com" <mfuller..._at_gmail.com> wrote:
> 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 -- Hide quoted text -
>
> - Show quoted text -

Legal, yes. But the real question is: Is it moral?

:) Received on Fri Mar 02 2007 - 13:32:52 CST