Re: PL/SQL Question

"Jeremy" <newspostings_at_hazelweb.co.uk> a écrit dans le message news: MPG.1a142a5d1c2f08be989926_at_news.individual.net...
>
> I seem to recall a feature where you could have an in-line procedure
> declared (i.e. sort of within the procedural code of another procedure).
> Tell me, am I imagining things?
>
>
> --
>
> jeremy

You can declare functions and procedures at the end of the DECLARE section of any PL/SQL block (anonymous, proc, functions). Actually I have never tried within the PL/SQL part of a trigger but it may be possible (imho, i can't see any thing that prevents it)

• anonymous PLSQL block DECLARE ... PROCEDURE my_proc IS BEGIN ... END; BEGIN my_proc; END;