Re: Global temporary tables v pl/sql tables

"Keld Nielsen" <keldnielsen_at_image.dk> wrote in message news:<M8iW8.157$s76.32298_at_news010.worldonline.dk>...
> Hi Richard,
> Just a small comment (embedded)
>
> "Richard Foote" <richard.foote_at_bigpond.com> wrote
> in message
> news:TsgW8.30694$Hj3.92875_at_newsfeeds.bigpond.com..
> .
> > Hi
> >
> > Just to add to what Robert has said.
> >
> > A GTT is actually quite permanent, it's the data
> within it that's temporary
> > (either at a transaction or session level).
> Therefore you can potentially
> > access data in a GTT through many PL/SQL block
> executions.
> >
> > A PL/SQL table is temporary, period, as it's a
> memory structure that exists
> > only for the life of the PL/SQL block.
>
> if it's created in a package body (or spec) it
> will exist during
> the life of a session - or am I wrong here ?
>

It needs to be DECLARED in the package spec to last the session.

CE Received on Tue Jul 09 2002 - 05:50:29 CDT