Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<c414fe$7o3$1_at_news4.tilbu1.nb.home.nl>...
> Debu Das wrote:
> > Hi Friends,
> >
> > In my stored procedure i am trying to create a temp table, populate
> > some data in it and then want to use it in the query.
> >
> > This is how i am trying to do
> >
> > EXECUTE IMMEDIATE 'CREATE GLOBAL TEMPORARY TABLE tt_Local(ID
> > VarChar2(38),Name VarChar2(50)) ON COMMIT PRESERVE';
> >
> > INSERT INTO tt_Local
> > SELECT
> > ID,
> > NAME
> > FROM
> > SCHEMATABLE
> > WHERE
> > ID = SuperclassID;
> >
> > After this i want this tt_Local table to be used in the query which i
> > will open it in a ref_cursor and send as a output paramaeter of the
> > stored procedure.
> >
> > I am getting this Compilation errors
> >
> > Error: PL/SQL: ORA-00942: table or view does not exist
> > Error: PL/SQL: SQL Statement ignored
> >
> > ####################################################################
> > I just tried to create the temporary table in the procedure with the
> > EXECUTE IMMEDIATE it got complied after that i tried to run the
> > procedure then i got this error
> > ORA-01031: insufficient privileges
> >
> > Any information provided will be greatly appreciated.
> >
> > Thanks in advance,
> >
> > Debu
>
> Don't cross post.
> Create the gtt beforehand - why would you create a temporary table on
> the fly?
Come to that, why would you use a temporary table at all in this scenario?
Received on Fri Mar 26 2004 - 08:40:12 CST
