Click here to Skip to main content
15,881,882 members
Please Sign up or sign in to vote.
4.67/5 (3 votes)
See more:
I have a C# program that requires to make a comparison of a CLOB data-type with a backend Oracle 11gR2 database.
The following is my code
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();

I got the error if the number of characters in the TextBox is more than 32K:

ORA-01460 unimplemented or unreasonable conversion requested

How can I overcome this?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900