Export (0) Print
Expand All

OracleLob.IsTemporary Property

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

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

Exception Type Condition
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 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: 

See Also

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

Show:
© 2014 Microsoft