Re: Help: Is there any way I can catch the sql that calls the function from inside the function?

Mr. Huang,

Thanks for your help. I am using Oracle 9204, but I do not mind upgrade it to 10G if you can prove it works in 10g.

The method you suggested did not work.

One way I am going to try on Monday is to use Fine Grained Auditing, and try to select from dba_fga_audit_trail, it might contains my sql there.

Somebody else suggested me to use PRAGMA AUTONOMOUS_TRANSACTION, which I need to do some research. Do you have any idea about that?

Thanks

<yong321_at_yahoo.com> wrote in message
news:1131736179.441319.69890_at_g47g2000cwa.googlegroups.com...
>
>
>
> There're two alternatives depending on what you really want to achieve.
> One is to use dbms_utility.format_call_stack inside your function
> instead of query of v$sql. The other is to generate SQL trace in the
> function and read the trace file (using external table e.g.) and find
> the cursor right before the SQL call inside the function.
>
> Yong Huang
>
Received on Sat Nov 12 2005 - 08:06:18 CST