This content has been marked as final. Show 1 reply
Welcome to the forum!
Unfortunately you have posted to the SQL Developer forum which, as the forum title says, is NOT for SQL and PL/SQL questions.
Please mark this thread ANSWERED and repost your question in the SQL and PL/SQL forum
When you repost your question you should provide the DDL for the two functions, not just a query in them. And unless those functions use the AUTONOMOUS_TRANSACTION pragma and a COMMIT then any inserts to a 'log' table that they do will not be permanent anyway.
You will also need to provide the row count that the SELECT query returns since if no rows are turned the first function may not even be being called.
Which raises this question: why are you logging information as part of a SELECT query anyway? What goal are you trying to achieve that justfies the performance penalty you are paying?