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 '15 at 15:27

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 '15 at 19:21
  • You need to use its External DLL Filter functionality. Sep 2 '15 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 '15 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 '15 at 20:00
  • API Monitor worked perfectly. Apparently i wasn't selecting application module while applying filter. Thanks.
    – AcarX
    Sep 2 '15 at 22:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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