PeopleTools - Database Level Auditing
Hi, I created a trigger using PeopleTools -> Utilities -> Audit -> Update Database Level Auditing in PT 8.53.
I generated the code for the Oracle DB but when I run the PL/SQL for the PeopleSoft generated trigger in our SQL tool (TOAD), it does not like the bind variables for new.fieldname or old.fieldname.
The code was run as Generated in the Utilities.
Anyone can suggest why the bind variable is an issue and workaround.
Thank you.