Great answer...
Philippe Marchand, November 30, 2018 - 4:11 pm UTC
Hi Connor,
Many many thanks for the quick feedback. This is what I was looking for. So using this you can easily rely this to the parent procedure or function. The only issue remaining is with anonymous PL/SQL block. Actually you can guess that the statement is coming from an anonymous PL/SQL as PROGRAM_LINE# is not 0 but you can’t rely to the block as it doesn’t have V$SQL.PROGRAM_ID and thus DBA_OBJECTS.OBJECT_ID, right?
Anyway this is a very useful information.
Thank’s again and have a great week end.
Philippe
December 03, 2018 - 3:26 am UTC
That is my understanding yes.