Re: why procedure turn unuseable

At first glance, i'm not sure what is causing your error. Maybe you have a dependency in the package to another package which is being invalidated, thus having an efect.

Does your package reference a temporary table?

Look at Note:106206.1 on Metalink, it may help resolve the problem.

M

yaosong_at_163.net (sunny) wrote in message news:<93040219.0302161859.750f7862_at_posting.google.com>...
> 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 - 03:06:43 CST