nick
nick

Reputation: 11

daab 5 update oracle NCLOB column

is there another way to fix this? i just find this works

DbCommand comm = db.GetStoredProcCommand(usp_Script_Update);
        db.AddInParameter(comm, "v_ID", DbType.String, WindowsGuid2OracleGuid(script.ID));
        db.AddInParameter(comm, "v_Name", DbType.String, script.Name);
        db.AddInParameter(comm, "v_Description", DbType.String, script.Description);

        ((OracleDatabase)db).AddParameter((OracleCommand)comm, "v_ScriptValue", OracleType.NClob, script.ScriptValue.Length,
            ParameterDirection.Input, true, 0, 0, "ScriptValue", DataRowVersion.Default, script.ScriptValue);

Upvotes: 0

Views: 231

Answers (1)

nick
nick

Reputation: 11

DbType.StringFixedLength

Upvotes: 1

Related Questions