Im using oracle10g,I have included "dbms_lob.getlength" to get length of a clob column,but its failing to fetch and throws error like ->
"ORA-00932: inconsistent datatypes: expected - got CLOB"
Please suggest some answers.
Asked
Active
Viewed 185 times
0
user1495475
- 997
- 3
- 17
- 33
-
Sorry,I found the problem of this,there was a "union" keyword being used,so it was the problem,this is fixed by adding "all" like "union all". – user1495475 Nov 05 '12 at 07:23
-
But is `union all` what you realley need ? – A.B.Cade Nov 05 '12 at 08:19
-
@A.B.Cade:No,i needed "dbms_lob.getlength" to be used to a CLOB column. – user1495475 Nov 05 '12 at 09:56
-
`union all` is not like `union` (http://stackoverflow.com/a/49928/1083652). Are you sure that changing the `union` keyword to `union all` gives you correct results? – A.B.Cade Nov 05 '12 at 11:09
-
@A.B.Cade:Yeah it works for me. – user1495475 Nov 05 '12 at 11:33