OracleMonitor Component question

OracleMonitor Component question

Postby 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
degas
 
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby hannes_a » Wed 12 Aug 2009 19:13

please send an example
hannes_a
 
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Postby 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.
Shalex
Devart Team
 
Posts: 7290
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle