Database Error Messages

OCI-57304

Cannot create validation directive 'string': Validation directive's USING clause is not side-effect free

Cause

An attempt is being made to create a validation directive which does not have side-effect free USING clause due to usage of UTL_HTTP or UTL_SMTP or UTL_TCP or an autonomous transaction.


Action

Ensure that UTL_HTTP/UTL_SMTP/UTL_TCP packages and autonomous transactions are not used from inside the validation directive's USING clause.