procedure call before insert, delete, update
Sašo C.Jun 5 2008 — edited Jun 6 2008Hi!
We have already implemented PL/SQL code for journal changes in tables. This mechanism requires that before insert, update, delete the PL/SQL procedure set_user_id is called, which set the PL/SQL package global variable and this variable is used in table triggers. Code in trigger actually write journaling information in separate tables.
This mechanism is used in client/server environment (like Oracle Forms) where set_user_id is called only once at the start of the session and is used for all DMLs in this session.
Now comes ADF and web on the scene.
Our JDevelopers programers claims that calling PL/SQL procedure before ADF actualy makes DMLs is complicated/imposible because it happens somewhere behind.
My question:
Have someone experience with this issue? I think it should be possible to place the call to the PL/SQL in general place for let say the JSP page where DMLs are initiated.
Regards,
Saso