Type: Interactive grid - Automatic Row Processing (DML) " Note: it is Default"
Target type: PLSQL Code
when 'C' then
when 'U' then
when 'D' then
Hi thanks for that, i was hoping for something that i wouldnt have to right PLSQL for each form but will use it if there isnt the function im looking for.
I have this same questions.
I want to update 2-3 tables with one form on one page and I'm not sure if the Automatic Row Processing (DML) tool is better or if I should try to use PL/SQL exclusively to update those tables. Hopefully someone can chime in to assist a little more.
You are reinventing the wheel here.
Have you considered Oracle's Auditing Feature:
What Is Auditing?
Auditing is the monitoring and recording of configured database actions, from both database users and nondatabase users.