ORA-43516
Cannot create directive 'string' on base object 'string': only AFTER OBJECT processing stage is allowed for the SELECT VALIDATION DIRECTIVE
Cause
The SELECT keyword as the ON clause only allows AFTER OBJECT as the PROCESSING clause in the VALIDATION DIRECTIVE.
Action
Specify AFTER OBJECT as the PROCESSING clause if SELECT keyword is mentioned in the ON clause of the CREATE DIRECTIVE statement.