Procedure Using Global Temporary Table Error

[inspi]

Hi ,
My stored procedure insert data in a global temporary 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 , 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!

 

[IanWaterman]

When I have used temporary tables in SPs, my last SQL statement is

Select * from Temptable


Ian

 

[IanWaterman]

Also does your Crystal Reports user for connecting to database have execeute rights for the SP.

Ian