OracleMonitor Component question

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
degas
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

OracleMonitor Component question

Post by degas » 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

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » 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.

hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Post by hannes_a » Wed 12 Aug 2009 19:13

please send an example

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » 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.

Post Reply