| |
- Causa
- DROP OR REVOKE ON OBJECT TYPE type1 CANNOT BE PROCESSED BECAUSE OBJECT name OF TYPE type2 IS DEPENDENT ON IT.
The requested action cannot be processed because a dependency exists on this type1.
type2 is the type of object that has the dependency on the type1 object involved in the DROP or REVOKE.
type2 can be one of the following:
- FUNCTION
- PROCEDURE
- TABLE
- VIEW
- TRIGGER (for the trigger package)
- CHECK CONSTRAINT (object_name contains the table name)
- DEFAULT (object_name contains the table name)
- DROP
- If type1 is FUNCTION, the dependencies for DROP might be:
- Another function is sourced on this function.
- A view uses this function.
- A trigger package uses this function.
- A table uses this function in a check constraint or
user-defined default.
The dependency might be on one of the generated cast functions
for a distinct type. If type1 is DISTINCT TYPE, the dependencies
for DROP might be:
- A parameter of a function is defined as this distinct type.
- A column of a table is defined as this distinct type.
- A parameter of a stored procedure is defined as this
distinct type.
If type1 is PROCEDURE, the dependencies for DROP might be:
- A trigger definition contains a CALL statement with the name
of this stored procedure
- REVOKE
- If type1 is FUNCTION, the dependencies for REVOKE might be:
- A function owned by the revokee is sourced on this function.
- A view owned by the revokee uses this function.
- A trigger package owned by the revokee uses this function.
- A table owned by the revokee uses this function in a check
constraint or user-defined default.
If type1 is DISTINCT TYPE, the dependencies for REVOKE might be:
- A parameter of a function owned by the revokee is defined as
this distinct type.
- A column of a table owned by the revokee is defined as this
distinct type.
- A parameter of a stored procedure owned by the revokee is
defined as this distinct type.
If type1 is PROCEDURE, the dependencies for REVOKE might be:
- A trigger definition owned by the revokee contains a CALL
statement with the name of this stored procedure.
This SQLCODE may also be issued when SYSADM is being revoked. When SYSADM
is revoked the cascading of the REVOKE statement may encounter
dependencies that prevent the REVOKE from being successfully processed.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Remove the dependencies on this object and then reissue the request.
SQLSTATE: 42893
© Copyright IBM Corp.
|
| |
