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 Received on Fri Apr 22 2005 - 12:14:50 CDT