I got error
"message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB SQL Text:"
when I select large string in nsql.
Check this (hope it helps) -
Hard Returns in NSQL dropped in Portlet
Don't think this is a "hard return" issue, its about BLOB/CLOB vs VARCHAR datatypes.
We can convert the CLOB to VARCHAR in the NSQL easily though, just wrap it in a to_char()
Oh.... ok ... Thanks for pointing it out, Dave
Retrieving data ...