Mark Langkau writes:
We have a data mart (MCMART) where tables and views are dropped and refreshed nightly. This seems to be the cause of the following error:
-- Error Message --
an exception occurred in a DTML method or document.
Error type: DatabaseError Error value: (4068, 'ORA-04068: existing state of packages has been discarded\012ORA-04061: existing state of package body "MCMART.MC_MART_RPT" has been invalidated\012ORA-04065: not executed, altered or dropped package body "MCMART.MC_MART_RPT"\012ORA-06508: PL/SQL: could not find program unit being called\012ORA-06512: at line 1')
Innermost method: /mc/mc_mart_dyn/mc_dd/daily_sales/show_daily_sales.dtml
------------------ If we reconnect to the Oracle database, the error goes away.
The connections from Zope to Oracle remain open during these nightly refreshes, and we are thinking this is causing the error. Is there a way to programatically close and reopen these connections? Sure!
Options: * play with the "Database" caching paramters * use "manage_close_connection"/"manage_open_connection" to do it under program control. You may use XRON to schedule it. Dieter