ORA-01410: invalid ROWID and Global Temporary Tables

Hi 

 We have an ASP.Net application which is used by many users (100+). There are situations where we need to hold session specific data per user so we use Global Temporary tables. We have localised an error  “ORA-01410: invalid ROWID” to the stored procedure using the global temporary tables.

The rough outline of the procedure is:

Create or Replace Proc1

Create an array of string values from an input parameter

Begin

                Insert into temp table based on conditional logic

                Open ref cursor /* to return to ASP.Net application */

                Select from temp table joined with other tables

End

End Proc1

The application was originally ported from Visual Basic which obviously works differently to a web application so I suspect there is an issue with using Global Temporary tables in a web application.