Re: why procedure turn unuseable

If the procedure is called from FORMS, check the dependency, is it signature or time stamp.
Recompiling the forms often solves the problem. (don't know why - nothing has seemingly changed, but it is 'recursive' until the form is recompiled; heavily dependent on version, but seen on several 6i's) Check the dependency tree of the package and check if any 'foundation' on the package is invalid, has changed or has been recompiled.

/Svend Jensen

sunny wrote:
> 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 Mon Feb 17 2003 - 13:16:11 CST