OracleLob.IsTemporary Properti

Definisi

Ruang nama:

System.Data.OracleClient

Rakitan:

System.Data.OracleClient.dll

Mendapatkan nilai yang menunjukkan apakah OracleLob adalah sementara LOB.

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

public bool IsTemporary { get; }

member this.IsTemporary : bool

Public ReadOnly Property IsTemporary As Boolean

Nilai Properti

Boolean

trueOracleLob jika adalah sementara LOB, jika tidak false.

Pengecualian

InvalidOperationException

Sambungan ditutup.

ObjectDisposedException

Objek ditutup atau dibuang.

OracleException

Terjadi kesalahan Oracle.

Keterangan

Contoh berikut menunjukkan cara membuat sementara 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