Re: Global temporary tables v pl/sql tables

"Charlie Edwards" <Charlie3101_at_hotmail.com> wrote in message
news:db479d88.0207090250.2ce2e835_at_posting.google.c om...
> "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

CREATE OR REPLACE PACKAGE x AS

 PROCEDURE y;
 end;
/
CREATE OR REPLACE PACKAGE BODY X AS
  TYPE emp_typ IS TABLE OF emp%ROWTYPE

       INDEX BY BINARY_INTEGER;
  emp_tab emp_typ;

PROCEDURE y IS
  CURSOR emp_cur IS
    SELECT * FROM emp
    ORDER BY empno;
...

so the table has been declared, but perhaps not DECLARED ! why has the table been declared in the body, do you think ? Received on Tue Jul 09 2002 - 11:50:18 CDT