OracleLob.IsTemporary Property

Definition

Namespace:

System.Data.OracleClient

Assembly:

System.Data.OracleClient.dll

Gets a value indicating whether the OracleLob is a temporary LOB.

public:
 property bool IsTemporary { bool get(); };

public bool IsTemporary { get; }

member this.IsTemporary : bool

Public ReadOnly Property IsTemporary As Boolean

Property Value

Boolean

true if the OracleLob is a temporary LOB, otherwise false.

Exceptions

InvalidOperationException

The connection is closed.

ObjectDisposedException

The object was closed or disposed.

OracleException

An Oracle error has occurred.

Remarks

The following example demonstrates how to create a temporary LOB.

OracleConnection connection = new OracleConnection("server=MyServer; integrated security=yes;");  
connection.Open();  
OracleTransaction transaction = connection.BeginTransaction();  
OracleCommand command = connection.CreateCommand();  
command.Transaction = transaction;  
command.CommandText = "declare xx blob; begin dbms_lob.createtemporary(xx, false, 0); :tempblob := xx; end;";  
command.Parameters.Add(new OracleParameter("tempblob", OracleType.Blob)).Direction = ParameterDirection.Output;  
command.ExecuteNonQuery();  
OracleLob tempLob = (OracleLob)command.Parameters[0].Value;  
tempLob.BeginBatch(OracleLobOpenMode.ReadWrite);  
tempLob.Write(tempbuff,0,tempbuff.Length);  
tempLob.EndBatch();  
command.Parameters.Clear();  
command.CommandText = "MyTable.MyProc";  
command.CommandType = CommandType.StoredProcedure;    
command.Parameters.Add(new OracleParameter("ImportDoc", OracleType.Blob)).Value = tempLob;  
command.ExecuteNonQuery();  
transaction.Commit();  
connection.Close