why procedure turn unuseable

Hi, exports

    A serious problem have confused me for a long time. my application is a oracle 8.1.7.4 server on hp N4000 cluster box (11.0 ), 800 user access it at the same time. some storage procedure often turns unuseable,and following error appear:
ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "GZVER2.BSP_DD_UP_ORDER"

ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "GZVER2.BSP_DD_SHEET_ORDER", line 480
ORA-06512: at line 1

 select * from dba_object where objec_name='BSP_DD_UP_ORDER show that the procedure is valid.

   after I use :alter prodedure BSP_DD_UP_ORDER compile , the procedure can be used, and every seem ok , but after some time , the same problem take place again. using select OWNER,OBJECT_NAME,OBJECT_TYPE,to_char(created,'YY-MM-DD-HH-MI') ,to_char(LAST_DDL_TIME,'YY-MM-DD-HH-MI'), timestamp,status from dba_objects order by LAST_DDL_TIME I 'm sure no object have be chaged before
the procedure turn unuseable. such thing happened again and again , and almost
make me crazy. pls give some advice

Thanks a lot

Sunny Received on Sun Feb 16 2003 - 20:59:54 CST