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

On this page
    Size Property (OracleLoaderColumn)
    On this page
    Gets or sets the maximum size, in bytes, of the data within the column.
    Syntax
    'Declaration
     
    Public Overrides Property Size As Integer
    public override int Size {get; set;}

    Property Value

    The maximum size, in bytes, of the data within the column.
    Remarks
    Use Size property to set maximum size in bytes of data for the column. Size is used only for string columns.
    Example
    public void GetDataColumns(OracleConnection oracleConnection)
    {
      oracleConnection.Open();
      OracleLoader loader = new OracleLoader();
      loader.Connection = oracleConnection;
      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
      {
        oracleConnection.Close();
      }
    }
    Public Sub GetDataColumns(ByVal oracleConnection As OracleConnection)
      oracleConnection.Open()
      Dim loader As OracleLoader
      loader = New OracleLoader
      loader.Connection = oracleConnection
      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
        oracleConnection.Close()
      End Try
    End Sub
    See Also