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
    See Also