Skip Headers
Oracle® Data Provider for .NET Developer's Guide
10g Release 2 (10.2)

Part Number B14307-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

OracleInfoMessageEventArgs Class

The OracleInfoMessageEventArgs class provides event data for the OracleConnection.InfoMessage event. When any warning occurs in the database, the OracleConnection.InfoMessage event is triggered along with the OracleInfoMessageEventArgs object that stores the event data.

Class Inheritance

Object

  EventArgs

    OracleInfoMessageEventArgs

Declaration

// C#
public sealed class OracleInfoMessageEventArgs

Thread Safety

All public static methods are thread-safe, although instance methods do not guarantee thread safety.

Example

// C#
 
using System;
using System.Data;
using Oracle.DataAccess.Client; 
using Oracle.DataAccess.Types;
 
 
class InfoMessageSample
{
  public static void WarningHandler(object src, 
    OracleInfoMessageEventArgs args)
  {
      Console.WriteLine("Source object is: " + src.GetType().Name);
      Console.WriteLine("InfoMessageArgs.Message is " + args.Message);
      Console.WriteLine("InfoMessageArgs.Source is " + args.Source);
  }
  static void Main()
  {
    OracleConnection con = new OracleConnection("User Id=scott;" + 
      "Password=tiger;Data Source=oracle;");
 
    con.Open();
 
    OracleCommand cmd = con.CreateCommand();
 
    //Register to the InfoMessageHandler
    cmd.Connection.InfoMessage += 
      new OracleInfoMessageEventHandler(WarningHandler);
 
    cmd.CommandText = 
      "create or replace procedure SelectWithNoInto( " +
      "  empname in VARCHAR2) AS " +
      "BEGIN " +
      "  select * from emp where ename = empname; " +
      "END SelectWithNoInto;";
 
    // Execute the statement that produces a warning
    cmd.ExecuteNonQuery();
 
    // Clean up
    cmd.Dispose();
    con.Dispose();
  }
}

Requirements

Namespace: Oracle.DataAccess.Client

Assembly: Oracle.DataAccess.dll


OracleInfoMessageEventArgs Members

OracleInfoMessageEventArgs members are listed in the following tables:

OracleInfoMessageEventArgs Static Methods

The OracleInfoMessageEventArgs static methods is listed in Table 5-63.

Table 5-63 OracleInfoMessageEventArgs Static Method

Method Description
Equals Inherited from Object (Overloaded)

OracleInfoMessageEventArgs Properties

The OracleInfoMessageEventArgs properties are listed in Table 5-64.

Table 5-64 OracleInfoMessageEventArgs Properties

Name Description
Errors Specifies the collection of errors generated by the data source
Message Specifies the error text generated by the data source
Source Specifies the name of the object that generated the error

OracleInfoMessageEventArgs Public Methods

The OracleInfoMessageEventArgs methods are listed in Table 5-65.

Table 5-65 OracleInfoMessageEventArgs Public Methods

Name Description
Equals Inherited from Object (Overloaded)
GetHashCode Inherited from Object
GetType Inherited from Object
ToString Inherited from Object


OracleInfoMessageEventArgs Static Methods

The OracleInfoMessageEventArgs static method is listed in Table 5-66.

Table 5-66 OracleInfoMessageEventArgs Static Method

Method Description
Equals Inherited from Object (Overloaded)


OracleInfoMessageEventArgs Properties

The OracleInfoMessageEventArgs properties are listed in Table 5-67.

Table 5-67 OracleInfoMessageEventArgs Properties

Name Description
Errors Specifies the collection of errors generated by the data source
Message Specifies the error text generated by the data source
Source Specifies the name of the object that generated the error

Errors

This property specifies the collection of errors generated by the data source.

Declaration

// C#
public OracleErrorCollection Errors {get;}

Property Value

The collection of errors.

Message

This property specifies the error text generated by the data source.

Declaration

// C#
public string Message {get;}

Property Value

The error text.

Source

This property specifies the name of the object that generated the error.

Declaration

// C#
public string Source {get;}

Property Value

The object that generated the error.


OracleInfoMessageEventArgs Public Methods

The OracleInfoMessageEventArgs methods are listed in Table 5-68.

Table 5-68 OracleInfoMessageEventArgs Public Methods

Name Description
Equals Inherited from Object (Overloaded)
GetHashCode Inherited from Object
GetType Inherited from Object
ToString Inherited from Object