ORA-43508
Cannot create directive 'string' on base object 'string': SELECT keyword is not allowed after ON keyword for the NOTIFICATION DIRECTIVE
Cause
The ON keyword can be followed by either INSERT, DELECT or UPDATE for the NOTIFICATION DIRECTIVE in the CREATE DIRECTIVE statement.
Action
Specify either INSERT, DELETE or UPDATE after the ON keyword for the NOTIFICATION DIRECTIVE in the CREATE DIRECTIVE statement.