Re: PL/SQL Question

In article <bod90c$35s1_at_news.rd.francetelecom.fr>, azerty_at_nospam.org says...
>
> "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;
>

Many thanks this is *exactly* what I was tring to recall!

cheers

-- 

jeremy