I wrote a stored procedure, for populating a global temporary table based on a where clause, and to return the results through a ref cursor. The procedure works fine from sqlworksheet. But, the report genereation is being made through crystal reports. When the procedure is executed from crystal reports, it comes out with ora-08103.
If I make the table , instead of a global temporary to a normal table, it is working fine with even crystal reports. I think, when procedure is executed from crystal reports, the work is being done in two sessions i.e., in the first session it populates the temporary table and in the second session it tries to retrieve the results, and due to the nature of the table, it comes out with ora-08103("The object has been deleted by another user since the operation began.")
Can anybody confirm, whether it is possible from crystal reports to execute a procedure which does the job of populating a global temporary table and also to fetch results from that table?