CLOB Behaviour different on Test and Deve Environment
961844Sep 14 2012 — edited Sep 14 2012Hi All,
I'm using below oracle version
Dev Database -
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
QA Database Details -
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
I’m facing one strange issue. Please help me out.
I’ve table with one column as CLOB
{
create table TEST_DEMO
(
DATABODY CLOB
);
}
And I’m executing below query.
{
select * from test_demo where databody is null or databody = '';
}
its working on DEV database and failing on Testing Database saying inconsistent data type.
I suspect this is chracterset issue.