Hi all,
We are using OWA_UTIL.WHO_CALLED_ME in our logging procedures so we can register exactly where a log-message was generated without having to code it ourselves and it works perfectly. Each log line contains the database object name and the line numer.
Until we started using a compound dml trigger. Then it suddenly misses the begin of the trigger name. See this image.
The yellow cells (eg line 19) indicate what is wrong, it should be like the green cells (eg. line 17). The value we expect is be "SRG.TR_LBS_PFC_DATA_CPD[352]" so we are missing are the first 15 characters.
I once found that this great function WHO_CALLED_ME was based on the PL/SQL Call Stack (?)
If I look at these there appears to be something missing for compound triggers:
Compound trigger call stack:
----- PL/SQL Call Stack -----
object line object
handle number name
0x875243f0 352 SRG.TR_LBS_PFC_DATA_CPD
0x8d7ada88 60 anonymous block
Non-compound trigger Call stack
----- PL/SQL Call Stack -----
object line object
handle number name
0x8d62ab20 1506 package body SRG.LBS_APEX4
0x8d53a818 16 anonymous block
0x87ed6848 1825 package body SYS.DBMS_SQL
0x873762c0 1880 package body APEX_050100.WWV_FLOW_DYNAMIC_EXEC
0x873762c0 936 package body APEX_050100.WWV_FLOW_DYNAMIC_EXEC
0xbe5c6298 71 package body APEX_050100.WWV_FLOW_PROCESS_NATIVE
The object type is not registred...
Does anyone know of a fix how to get this solved?
Thanks,
Herman