Comments by Teamsar Muliadi (Top 39 by date)

You can try this one :

public void DoInsertDataIncomingMsg(object sender)
{
OracleConnection objCon = new OracleConnection(CReaderConfig.StructureAppSettings.connStringAkses);
try
{
objCon.Open();
oTransc = objCon.BeginTransaction(IsolationLevel.Unspecified);
//oTransc.IsolationLevel = IsolationLevel.ReadCommitted;
oCommand = objCon.CreateCommand();
oCommand.Transaction = oTransc;
if (oCommand.Transaction == null)
{
log.Debug("Transaction 1 is null");
}
oCommand.CommandText = CQuery.Q_INSERT_INTO_T_INCOMING_MSGS(((CCommonStruct)sender).incoming_date,
((CCommonStruct)sender).membercode, ((CCommonStruct)sender).status_code,
((CCommonStruct)sender).getReferenceID);
oCommand.ExecuteScalar();

byte[] newvalue = System.Text.Encoding.Unicode.GetBytes(((CCommonStruct)sender).get_clob_messages);
log.Debug("New value : " + System.Text.Encoding.Unicode.GetString(newvalue));
log.Debug("Reference ID : " + ((CCommonStruct)sender).getReferenceID);

oCommand.CommandText = CQuery.Q_UPDATE_T_INCOMING_MSGS(((CCommonStruct)sender).getReferenceID);
if (oCommand.Transaction == null)
{
log.Debug("Transaction 2 is null");
}
using (OracleDataReader reader = oCommand.ExecuteReader())
{
reader.Read();
global::System.Data.OracleClient.OracleLob clob = reader.GetOracleLob(0);
clob.Write(newvalue, 0, newvalue.Length);
}
oTransc.Commit();
}
catch (Exception ex)
{
oTransc.Rollback();
log.Debug("Error while executing DoInsertDataIncomingMsg for Reference ID : " + ((CCommonStruct)sender).getReferenceID, ex);
}
finally
{
if (objCon != null)
{
objCon.Close();
oTransc.Dispose();
}
}
}

Mmm.. after i read the link (msdn) above, i have a question for you. How about destructor if we don't have constructor ?? Thanks :)

It means that if we want to implement IDisposable interface, the class(es) must have constructor, doesn't it ?
(after i read your links).

Hey... it works... :) thanks for giving me solution.. :)