Devart Forums

Posted: **Fri 31 Jul 2009 18:26**

I want use the Oracle Monitor component i my application but i can only get the sql/pl-sql statement that is being excuted.
But i want a more complex information, like the one that the DBMonitor provides me.
Especially, when passing variable, i wnt to be able to retrieve the values that are passed.

Is this possible? I have a proedition license.

Tahnks a lot

Posted: **Mon 03 Aug 2009 07:52**

You can obtain the desired information if you cast the proper event sender to the command object and inspect the Parameters collection.

Posted: **Wed 12 Aug 2009 19:13**

please send an example

Posted: **Thu 13 Aug 2009 11:07**

Here is a handler of OracleMonitor.TraceEvent:

Code: Select all

static void mon_TraceEvent (object sender, Devart.Common.MonitorEventArgs e) {
  OracleParameterCollection parameters = null;
  if (e.EventType == Devart.Common.MonitorEventType.Execute)
	parameters = ((OracleCommand)sender).Parameters;
}

Hannes_a, we have sent you a whole test project to your e-mail.

Devart Forums

OracleMonitor Component question

OracleMonitor Component question