[Zope] DCOracle problems after dropping/reloading tables

[Dieter Maurer]

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