This content has been marked as final. Show 2 replies
In order for CLOB to work, both the column type in Oracle and the parameter type in C# need to be Clob. I'm not sure you can use that with what appears to be an XML table. Might be worth checking anyway though, since currently your type in C# is varchar2.
for XMLtable(it not permenant table in oracle) i iam passing as string i used
oracleCommand.Parameters.Add(":IDLIST", OracleDbType. Clob);
oracleCommand.Parameters[":IDLIST "].Value = idList;