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 -- //www.freelists.org/webpage/oracle-l