OracleLob.IsTemporary Property

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

[Visual Basic]
Public ReadOnly Property IsTemporary As Boolean
[C#]
public bool IsTemporary {get;}
[C++]
public: __property bool get_IsTemporary();
[JScript]
public function get IsTemporary() : Boolean;

Property Value

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

Exceptions

Remarks

The following example demonstrates how to create a temporary LOB.

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

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

.NET Framework Security: 

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries From Partially Trusted Code

See Also

OracleLob Class | OracleLob Members | System.Data.OracleClient Namespace