Need jdbc SQL query of the stored procedure invoke

What product/components do you use and which version/fix level are you on?

webMethods 10.5

Is your question related to the free trial, or to a production (customer) instance?

production instance

What are you trying to achieve? Please describe it in detail.

We are making stored procedure jdbc calls and sometimes it fails at the database side.
So, we want the actualy sql query which is hitting the db with the actual parameters.

We have tried increasing the adapter logging level to trace. If we use dynamic adapter service, then we are able to see the query in the logs but not with stored procedure. Also, tried spy option in the jdbc pool, no luck. Any help/suggestion would be appreciated.

Do you get any error messages? Please provide a full error message screenshot and log file.

Have you installed all the latest fixes for the products and systems you are using?

yes