Re: Global Temporary Tables

From: Oxnard <shankeypNO_SPAM_at_comcast.net>
Date: Fri, 22 Apr 2005 13:17:14 -0500
Message-ID: <Zf2dneRnTf82ovTfRVn-vQ@comcast.com>

"Roy Munson" <mtproc_at_yahoo.co.uk> wrote in message news:853055e7.0504220914.5e7640b8_at_posting.google.com...
> Each,
>
> Am wanting to create a temporary table within a PLSQL package. Have
> used
>
> EXECUTE IMMEDIATE 'create global temporary table temp_status........'
>
> Problem now is that package wont compile due to insert statements for
> this table. Compiler has no idea about this temp table or its
> structure.
>
> I take it temporary tables arent designed for this use are am i
> missing something here?
>
> Cheers

search for 'dynamic sql' Received on Fri Apr 22 2005 - 13:17:14 CDT