SYS_CONTEXT('USERENV','CURRENT_SQL')
440902Dec 19 2006 — edited Dec 20 2006I am trying to select above function from dual to capture the user issued sql text but it always returns blank/spaces.
I basically have a DDL trigger that captures other info in sys_context and they come out OK.
Is there some specific way I should use this or different way to capture the user issed sql statements?
Thx