Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Getting the calling SQL statement in a PL/SQL function
A programmer here asked me whether there was a way for him, inside a
function, to obtain the SQL used to call the function. He's tried
identifying the calling session and then looking into v$sqlarea to get
the sql executed by that session, but what shows there is the sql
being executed by his function. Is there a good way to find the
calling sql with certainty?
Thanks,
Glenn
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 12 2006 - 17:43:57 CST
![]() |
![]() |