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

Home -> Community -> Usenet -> c.d.o.misc -> count PL/SQL function calls

count PL/SQL function calls

From: JBB <merci_at_pasdespam.fr>
Date: Wed, 10 Aug 2005 13:01:08 +0200
Message-ID: <42f9de75$0$26018$636a15ce@news.free.fr>


I've a big SQL request (whith nested select) which use a PLS/SQL function for filter.

SELECT
...
FROM
   ( SELECT ...
        WHERE FIELD = myFunction(param1..)
    )
WHERE ... I want to count how many times myFunction is called. How to do this ?
myFunction can't write in a table nether use a SEQUENCE or have an IN OUT parameter. If it does SQL doesn't work.

Is there a tool ( a profiler) in TOAD to do that?

Thanks Received on Wed Aug 10 2005 - 06:01:08 CDT

Original text of this message

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