This content has been marked as final. Show 3 replies
Is this behavior specific to proxy authentication? The usual "problem" with global temporary tables is that the data is deleted on commit, and the default for odp.net is to commit.
Generally you work around it by changing the temp table to be ON COMMIT PRESERVE ROWS or wrapping the ODP code in a local transaction.
Does the behavior still occur with connection pooling off? What about with Statement Cache Size=0?
Where did you get this error from? I doubt that that is a SELECT statement ("returning resultsets to our client"). Moreover this error is specific to Oracle 9 and earlier and is absent in Oracle10g. The error description is
Cause: A ROWID was entered incorrectly. ROWIDs must be entered as formatted hexadecimal strings using only numbers and the characters A through F. A typical ROWID format is '000001F8.0001.0006'.
Action: Check the format, then enter the ROWID using the correct format. ROWID format: block ID, row in block, file ID
If you use ROWIDs to access rows in GTT and use inexistent ROWID then you should have got empty result set, not this error.
Your suggestion did the trick!