Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Global (and local) Temporary Tables & PL/SQL
Raj and Gints,
Thank you for the additional information.
I think I have convinced the developer to create the table in advance and outside of his PROC. However, now he has gotten more information and the business may actually have a need for this in-transit data (various status codes and dates) so now he is considering making it a permanent table. I hope I have convinced him to implement a data purge from the time this goes into production, but seems like we won't be needing GTT's for this purpose anyway.
-- Stephen Andert http://andertfamily.net/racing_reports.aspx Any idiot can run. It takes a special kind of idiot to run a marathon. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 04 2007 - 10:58:29 CDT