Re: Global Temporary Tables

Roy Munson wrote:
> 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

Please read the concepts manual about global temporary tables, and forget those M$ programming practices.

There can be no valid reason to create (global temporary or other) tables, using pl/sql (a.k.a. on-the-fly).

And now that you're asking - yes you completely missed the purpose of global temporary tables - as well as the Oracle transaction model, I assume.

-- 
Regards,
Frank van Bortel