This content has been marked as final. Show 3 replies
this works fine when you set this value in APEX apllication.
My situation is little different.
I have first table with field CREATED_BY. This field is populated through trigger:
:NEW.CREATED_BY := v('F_USER');
Everything is OK when you add record through APEX application.
Now, I need to add record in first table through trigger of second table.
In second table only way to add record is from Oracle Forms.
In this situation trigger doesn't see F_USER APEX application item and field CREATED_BY