Delete

This method deletes the referenced object from the database.

Declaration

// C# - managed and core ODP.NET
public void Delete();
// C# - unmanaged ODP.NET
public void Delete(bool bFlush);

Parameters

  • bFlush

    A bool that specifies whether or not the REF is flushed immediately.

Remarks

This method marks the specified REF for deletion.

In managed ODP.NET and ODP.NET Core, Delete() has the same behavior as unmanaged ODP.NET Delete(true).

Depending on whether the value of bFlush is set to true or false, the following occurs:

  • True

    The object referenced by the specified REF is deleted immediately from the database.

    Before flushing objects, it is required that the application has explicitly started a transaction by executing the BeginTransaction method on the OracleConnection object. This is because if the object being flushed has not already been locked by the application, an exclusive lock is obtained implicitly for the object. The lock is only released when the transaction commits or rollbacks.

  • False

    The object referenced by the REF is not deleted immediately from the database, but only when a subsequent Flush method is invoked for the specified REF or the FlushCache method is invoked on the OracleRef or the FlushCache method is invoked on the OracleRef connection.

See Also: