Re: Help: ORA-04067: not executed, package body "SYSTEM.OWA" does not exist

I know of two possible reasons:

1. the user does not have rights to execute a stored procedure.
   • check if the user has appropriate rights to execute the stored procedure. including DML operations of tables.
2. the stored procedure has been invalidated for some reason. Eg: if you drop and re-create a table accessed by your procedure (in your package). In the event of such a thing, you will have to re-compile your procedures associated with the package.

please run a query against the all_objects table to find out if there are objects in your schema with status 'INVALID'. Please re-compile all INVALID procedures associated with your processing needs and then run the application.

I can't think of any other reasons other than the above two.

cheers
- Ram

Siuchi wrote:

> Dear all,
>
> I have a error when I test my login page:
>
> Error occured while accessing
> "/abc/plsql/login"
> at Fri Jul 27 16:01:02 2001
>
> OWS-05101: Execution failed due to Oracle error 4068
> ORA-04068: existing state of packages has been discarded
> ORA-04067: not executed, package body "SYSTEM.OWA" does not exist
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
> PL/SQL Cartridge SERVICE: abc
> PROCEDURE: login
>
> However, when I modify change the database user of the DAD to a DBA user.
> It work fine.
>
> I wonder if there is something I should do on my database user.
>
> Any help is highly appreciated !!
>
> Regards,
> Christine
Received on Tue Jul 31 2001 - 06:40:53 CEST