cmd.Text = SELECT COUNT(*) FROM TEST_TABLE t1 WHERE DBMS_LOB.COMPARE(t1.CLOB_COLUMN, :INPUT_TEXT); OracleParameter oraPara = new OracleParameter("INPUT_TEXT", OracleType.Clob); OraPara.Value = txtBox1.Text; //Text Box can have more than 32K characters cmd.Parameters.Add(oraPara); int i = cmd.ExecuteScalar();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)