Alternative to temporary tables

The situation:
I currently have stored procedures that use global temp tables to hold differing type of query criteria that is passed in to the procedure. This enables me to easily do a join of these temp tables with various permanent tables to find data a user is interested in. However, I am running oracle 9.2 and am running into the unresolved bug in which a huge amount of redo data is generated when inserting into temp tables. This has caused havoc in our database with lots of other applications failing due to no rollback space.

I know I could parse out the criteria and create some complicated where clauses to include the criteria directly but I think there must be an easier way. Can anyone suggest a replacement for temporary tables? I've not used many of the pl/sql collections yet.

I am not willing to upgrade to 10 just to solve this problem so any advice will be greatly appreciated. Received on Thu Oct 05 2006 - 10:14:12 CDT