Tony wrote:
> 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?
Right - I've pondered the keyboard too fast once again.
Let me guess - SS2K background/TSQL experience?
--
Regards,
Frank van Bortel
Received on Fri Mar 26 2004 - 15:12:49 CST
