SQL & PL/SQL

Hi,

I am trying to execute from my C/C++ application (based on OCCI) two queries in UNION returning a BLOB field.

The tables are:
- CREATE TABLE T1 (int i1, blob b)
- CREATE TABLE T2 (int c1, blob c)

My query is (SELECT i1, b, length(b) FROM T1) UNION (SELECT c1, c, length(c) FROM T2)

But, executing this query from my C/C++ applicaton interfacing Oracle 9 via OCCI I got the error: ORA-00932: inconsistent datatypes: expected - got BLOB

If I execute only one of the two queries (without the UNION clause):
- SELECT i1, b, length(b) FROM T1
- SELECT c1, c, length(c) FROM T2

Any ideas why, the UNION of select with blob report that error.

Thanks in advance for the help