ORA-01704: String Literal Too Long - Help!!

[irosa]

Thanks for the info. The only problem is that I am using ColdFusion to execute the query. I figured it out though. CF has a parameter that converts the variable to CLOB datatype.

Example query in CF:


UPDATE MKT_Page_Links
SET LongDescription =
WHERE MenuIDNO = #form.ID#