Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Getting the calling SQL statement in a PL/SQL function

Getting the calling SQL statement in a PL/SQL function

From: Glenn Stauffer <alaxsxaq_at_gmail.com>
Date: 2006-01-12 17:43:57
Message-id: ba9513280601120843l39ed2013n4bec04c0056ce211@mail.gmail.com


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
Received on Thu Jan 12 2006 - 17:43:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US