CCS: Invalid Datatype with Oracle CLOB columns?

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

CCS: Invalid Datatype with Oracle CLOB columns?

Author

Message

george l.

Posted: 09/12/2002, 12:22 PM

I have been having problems trying to search a CLOB column in C.C.S. I keep getting errors similar to this:
ORA-00932: inconsistent datatypes
Query :"SELECT COUNT(*) FROM NOTIFS WHERE "NOTIF_TITLE" like '%D%' OR "NOTIF" like '%D%'"

Can someone tell me if Oracle CLOBs are supported using CodeCharge Studio?

Ron

Posted: 09/16/2002, 1:43 AM

George,
as I know CCS doesn't support BLOBs and CLOBs, only MEMO which is actually a varchar

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login