Clob and comparision

Posted in 2007

KRISHNAKANTH VINNAKOTA — Tue, 09 Oct 2007 10:45:56 — source: IIUG Forums & Mailing Lists

in google search i found something like this "No casts exist for CLOB data. Therefore, the database server cannot convert data of the CLOB type to any other data type and vice versa. Within SQL, you are limited to the equality (=) comparison operation for CLOB data" so i wrote a query selet t1.x,t2.y from t1,t2 where t1.clob_column = t2.varchar_column1 || t2.varchar_column2 but the query fails with following error Routine (equal) can not be resolved. can any one help me

↪ replying to KRISHNAKANTH VINNAKOTA

KRISHNAKANTH VINNAKOTA — Mon, 15 Oct 2007 10:08:42 — source: IIUG Forums & Mailing Lists

Solution working for me..... selet t1.x,t2.y from t1,t2 where (t1.clob_column)::lvarchar = (t2.varchar_column1 || t2.varchar_column2 ) please suggest if you have any alternatives.....

↪ replying to KRISHNAKANTH VINNAKOTA

ART KAGEL, BLOOMBERG/ — Mon, 15 Oct 2007 13:50:30 — source: IIUG Forums & Mailing Lists

If you don't include the original post and especially if you change the subject line, many of us will not/do not know what problem you refer to having solved! Art S. Kagel ----- Original Message ----- From: Krishnakanth Vinnakota <ids@iiug.org> To: ids@iiug.org At: 10/15 6:09:04 Solution working for me..... selet t1.x,t2.y from t1,t2 where (t1.clob_column)::lvarchar = (t2.varchar_column1 || t2.varchar_column2 ) please suggest if you have any alternatives..... ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.