dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleLoaderColumn Class / OracleDbType Property
Example

In This Topic
    OracleDbType Property (OracleLoaderColumn)
    In This Topic
    Gets or sets the OracleDbType of the column.
    Syntax
    'Declaration
     
    Public Property OracleDbType As OracleDbType
    public OracleDbType OracleDbType {get; set;}

    Property Value

    A OracleDbType value of the column. The default value is OracleDbType.VarChar.
    Remarks
    Use OracleDbType property to specify Oracle data type for the column.
    Example
    public void GetDataColumns(OracleConnection myConnection)
    {
      myConnection.Open();
      OracleLoader loader = new OracleLoader();
      loader.Connection = myConnection;
      loader.TableName = "load_table";
      OracleLoaderColumn myColumn;
      try
      {
        loader.CreateColumns();
        for (int i = 0; i < loader.Columns.Count; i++)
        {
          myColumn = loader.Columns[i];
          Console.WriteLine(myColumn.Name);
          Console.WriteLine(myColumn.OracleDbType.ToString());
          Console.WriteLine(myColumn.Size);
          Console.WriteLine(myColumn.Scale);
          Console.WriteLine(myColumn.Precision);
          Console.WriteLine();
        }
       }
      finally
      {
        myConnection.Close();
      }
    }
    Public Sub GetDataColumns(ByVal myConnection As OracleConnection)
      myConnection.Open()
      Dim loader As OracleLoader
      loader = New OracleLoader
      loader.Connection = myConnection
      loader.TableName = "load_table"
      Dim myColumn As OracleLoaderColumn
      Try
        loader.CreateColumns()
        Dim i As Integer
        For i = 0 To loader.Columns.Count - 1
          myColumn = loader.Columns(i)
          Console.WriteLine(myColumn.Name)
          Console.WriteLine(myColumn.OracleDbType.ToString())
          Console.WriteLine(myColumn.Size)
          Console.WriteLine(myColumn.Scale)
          Console.WriteLine(myColumn.Precision)
          Console.WriteLine()
        Next i
      Finally
        myConnection.Close()
      End Try
    End Sub
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also