Re: Global Temporary Tables

> 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

You should create the global temporary table once. Each session can access it, but one session will not see the data another session has entered into this table.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/