Devart Forums

Code: Select all

Specified cast is not valid.
   at Devart.Data.Oracle.OracleUtils.a(Object A_0, OracleDbType A_1, Boolean A_2)
   at Devart.Data.Oracle.OracleParameter.e(Object A_0)
   at Devart.Data.Oracle.OracleParameter.get_OracleValue()
   at E247.CMS.Web.Global.oracleMonitor1_TraceEvent(Object sender, MonitorEventArgs e) in Global.asax.cs:line 45
   at Devart.Common.DbMonitor.OnTraceEvent(Object sender, MonitorEventArgs e, Boolean parentMessage)

Code: Select all

context.LmCategories.DeleteOnSubmit(lmCategory);
context.SubmitChanges();

Code: Select all

DELETE FROM MUSIC_247.LM_CATEGORIES WHERE CATEGORY_ID = :key1 
AND ATTACH_ID = :key2 
AND SEQ_NO = :chk1 
AND ((:nullchk2 = 1 AND TEXT_ID IS NULL) OR (TEXT_ID = :chk2)) 
AND ((:nullchk3 = 1 AND FILTER_TYPE IS NULL) OR (FILTER_TYPE = :chk3)) 
AND ((:nullchk4 = 1 AND FILTER_VALUE IS NULL) OR (FILTER_VALUE = :chk4))

Code: Select all

protected static Devart.Data.Oracle.OracleMonitor oracleMonitor1;
protected Devart.Data.Oracle.OracleTrace oracleTrace;

static void Main(string[] args) {
    oracleMonitor1 = new Devart.Data.Oracle.OracleMonitor { IsActive = true };
    oracleMonitor1.TraceEvent += new MonitorEventHandler(oracleMonitor1_TraceEvent);

    TestDataContext dc = new TestDataContext() { Log = Console.Out };
    Int32 ArticleVersionID = 1;
    var first = dc.TestLongs.First(tl => tl.Id == ArticleVersionID);
    dc.TestLongs.DeleteOnSubmit(first);
    dc.SubmitChanges();
}

private static void oracleMonitor1_TraceEvent(object sender, MonitorEventArgs e) {
    if (e.EventType.ToString() == "Execute" && e.TracePoint.ToString() == "AfterEvent") {
        var cmd = (OracleCommand) sender;
        if (cmd != null) {
            string parameterBuilder = "";
            foreach (OracleParameter param in cmd.Parameters) {
                parameterBuilder += param.ParameterName + " = " + param.OracleValue.ToString() + "(" +
                param.OracleDbType + "); ";
            }
        }
    }
}