I have an application which is executing oci statements using OCIStmtExecute(). I need to know which sql statement is being passed to OCIStmtPrepare on what action. Tried using API Monitor but there weren't OCI.dll functions. Also placing a breakpoint doesn't help since it's executing a notify statement almost every half a second.

  • If you use WinDbg, you can set a breakpoint, have it dump out the parameter, then continue execution.
    – josh poley
    Sep 2, 2015 at 15:27

1 Answer 1


Tried using API Monitor but there weren't OCI.dll functions.

OCI.dll most certainly does export functions, including OCIStmtExecute() and OCIStmtPrepare():


If you're not seeing them in API Monitor, it's because you've not told API Monitor to log them correctly, or because they're not really being called by the target process.

  • How do i tell API Monitor to log them ? I'm certain that the application is using those functions.
    – AcarX
    Sep 2, 2015 at 19:21
  • You need to use its External DLL Filter functionality. Sep 2, 2015 at 19:32
  • I'm checking boxes next to functions but it doesnt help. Do i need to set another filter for them from somewhere ?
    – AcarX
    Sep 2, 2015 at 19:44
  • You may want to post your question on API Monitor's web forum: rohitab.com/discuss/forum/1-api-monitor Sep 2, 2015 at 20:00
  • API Monitor worked perfectly. Apparently i wasn't selecting application module while applying filter. Thanks.
    – AcarX
    Sep 2, 2015 at 22:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.