OracleLob.IsTemporary Propiedad

Definición

Obtiene un valor que indica si OracleLob es un LOB temporal.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

Valor de propiedad

Es true si OracleLob es un LOB temporal; en caso contrario, es false.true if the OracleLob is a temporary LOB, otherwise false.

Excepciones

La conexión está cerrada.The connection is closed.

El objeto estaba cerrado o desechado.The object was closed or disposed.

Se produjo un error de Oracle.An Oracle error has occurred.

Comentarios

En el ejemplo siguiente se muestra cómo crear un LOBtemporal.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  

Se aplica a