04060-04069: Stored Procedure Execution Messages

ORA-04060: insufficient privileges to execute name

Cause: An attempt was made to execute a stored procedure without sufficient privileges.

Action: Obtain the necessary privileges through direct grants of the privileges, not through roles.

ORA-04061: existing state of name has been invalidated

Cause: An attempt was made to resume the execution of a stored procedure using the existing state, which has become invalid or inconsistent because the stored procedure has been altered or dropped.

Action: Attempt the action again. This action should cause the existing state of all packages to be reinitialized.

ORA-04062: name of name has been changed

Cause: An attempt was made to execute a stored procedure to service a remote procedure call stub that specifies a timestamp or signature that is different from the current timestamp or signature of the procedure.

Action: Recompile the caller to obtain the new timestamp.

For more information about obtaining a timestamp, see the index entry on "timestamp conflict resolution method" in Oracle8 Server Distributed Systems.

ORA-04063: name has errors

Cause: An attempt was made to execute a stored procedure that has errors. For stored procedures, the problem could be syntax or references to other, non-existent procedures. For views, the problem could be a reference in the view's defining query to a non-existent table.

Can also be a table which has references to non-existent or inaccessible types.

Action: Fix the errors and create referenced objects as necessary.

ORA-04064: not executed, invalidated name

Cause: An attempt was made to execute a stored procedure that has been invalidated.

Action: Recompile the procedure and its dependents.

ORA-04065: not executed, altered, or dropped name

Cause: An attempt was made to execute a stored procedure that has been altered or dropped.

Action: Recompile the procedure's dependents.

ORA-04066: non-executable object, name

Cause: An attempt was made to execute an object that is not a package, procedure, or function.

Action: Check that a correct name is used.

ORA-04067: not executed, name does not exist

Cause: An attempt was made to execute a package, procedure, or function that does not exist.

Action: Check the name in the command.

ORA-04068: existing state of packages has been discarded

Cause: An error occurred when attempting to execute a stored procedure.

Action: Refer to the accompanying messages and fix the error mentioned. Try the procedure again after proper reinitialization of any application's state.

---