-20072 csect-name bind-type bind-subtype ERROR USING authorization-id AUTHORITY. OPERATION IS NOT ALLOWED ON A package-type PACKAGE package-name
Explanation
The bind subcommand bind-type with bind-subtype is not valid for the type of package specified for one of the following reasons:
- The subcommand REBIND TRIGGER PACKAGE can be used only for trigger packages.
- The subcommand BIND PACKAGE DEPLOY can be used only for SQL functions or native SQL procedure packages.
- The subcommand FREE PACKAGE can be used only for packages that are not associated with triggers, native SQL procedures, or compiled SQL functions.
- csect-name
- The name of the control section that issued the message.
- bind-type
- The type of bind subcommand: REBIND or FREE.
- bind-subtype
- The subtype of bind subcommand: TRIGGER or DEPLOY.
- authorization-id
- The authorization ID that is attempting the prohibited action.
If you are using a trusted context, the token authorization-id might return a role instead of an authorization ID. A role is returned if a role was in effect and the authorization checking is performed against the role rather than the authorization ID of the session when the condition was encountered.
- role-name
- The name of the role, in the format: 'Role: role-name'
- package-type
- The type of package: trigger, SQL function, or native SQL procedure.
- package-name
- The name of the package, in the format 'collection.package'.
System action
The package that is specified is not deployed, rebound, or freed.
System programmer response
For a package that is not a trigger package, rebind using the subcommand REBIND PACKAGE. Call the bind subcommand again, and specify a collection package that is an accepted package.
SQLSTATE
56052