Procedure Using Global Temporary Table Error

[inspi]

Hi ,
My stored procedure insert data in a global temporary table(on commit delete rows type table) in Oracle depending on the parameter we pass to the procedure. The stored procedure returns a result set from ref cursor of this data. When I try accessing the stored procedure through Crystal reports 2008(using crystal ODBC) , it gives me an error ,

ORA-08103 object no longer exists.

When I run it in TOAD it runs absolutely fine.
Are global temporary tables not supported in Crystal reports 2008? or am I going wrong somewhere?
This is something very urgent.
Appreciate your immediate response.
Thanks!

 

[Wallie12]

You have answered your own question "global temporary table"
When you are using a global temporary table it is deleted when the process ends. Change the table type and use
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[table name]') AND type in (N'U'))
DROP TABLE [dbo].[table name] prior to running the process again.