Re: PL/SQL Question

From: Alkos <azerty_at_nospam.org>
Date: Thu, 6 Nov 2003 15:01:21 +0100
Message-ID: <bodk7i$3ca2@news.rd.francetelecom.fr>

"Jeremy" <newspostings_at_hazelweb.co.uk> a écrit dans le message news: MPG.1a143d6389583356989928_at_news.individual.net...
> 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

You're welcome.
My intuition is actually better than my knowledge of Oracle ;o)

Alkos Received on Thu Nov 06 2003 - 08:01:21 CST