1

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
1

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

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

OCIStmtExecute

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. – Jason Geffner 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 – Jason Geffner 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.