On Mar 2, 2:32 pm, "rogergor..._at_gmail.com" <rogergor..._at_gmail.com>
wrote:
> 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?
>
> :)- Hide quoted text -
>
> - Show quoted text -
Well, to avoid having to answer the question one could use "pragma
ignore_morality" in the outermost declare block.
Received on Fri Mar 02 2007 - 14:01:29 CST
