-658 A object-type CANNOT BE DROPPED USING THE statement STATEMENT
Explanation
A DROP statement was issued, but the object cannot
be explicitly dropped. The object must be dropped by dropping an associated
object:
- TRIGGER PACKAGE
- A trigger package cannot be dropped with the DROP PACKAGE statement. A trigger package can only be dropped implicitly when the associated trigger is dropped using the DROP TRIGGER statement.
- CAST FUNCTION
- A cast function cannot be explicitly dropped with the DROP FUNCTION statement. A cast function can only be dropped implicitly when the associated distinct type is dropped using the DROP DISTINCT TYPE statement.
- ROW PERMISSION
- A default row permission cannot be explicitly dropped with the DROP PERMISSION statement. A default row permission can only be dropped implicitly when the associated table is dropped using the DROP TABLE statement. Alternatively, the default row permission can be dropped by using the ALTER TABLE statement with the DEACTIVATE ROW ACCESS clause.
System action
The statement cannot be processed.
Programmer response
Issue the appropriate DROP statement to drop the intended objects.
SQLSTATE
42917
