Getting the calling SQL statement in a PL/SQL function
- From: Glenn Stauffer <alaxsxaq@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 12 Jan 2006 11:43:57 -0500
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-l
Other related posts: