Hello,
On a project, I need to dynamicaly create triggers on an Oracle database. In the syntax of the trigger, the new row is referenced by ":new". My first attempts of using native queries to execute the CREATE TRIGGER statement resulted in
exceptions implying the colons that were in my query.
So I wondered if there was either a way of escaping the colon character (doubling the colon does not seem to work), or another way of executing my request.
Thanks by advance for your answers.
Romaric PASCAL
Atos Worldline - Responsable d'Application
Tel. 04 78 17 88 21