oracle-databaseplsqltemp-tablesrefora-00600

Global temporary table of object type with ref attribute

In oracle 9i database, I have a table of objects type. The object has a REF attribute. When i do "select deref..." works fine.

THE PROBLEM IS: Due to architectural issues, i have to make the table a GTT (global temporary table). Now when i do "select deref..." give me the error ORA-00600 ... [2147483647] ...

Can I have REF attributes on a GTT ? (google give me nothing about this)

If not.. how can i resolve the cycle dependence problem in GTT ?

Thanks in advance

Solution

  • Ok... I find the solution..

    GTT on oracle don't let references be type of a column.

    I take the reference, put a Id (like a foreign key) and it's ok. For my porpose it work.

    APC thanks for your answer...