union all and ORA-12704: character set mismatch
802808Mar 13 2011 — edited Mar 13 2011I am using union all to join two result set together,
e.g.
select product, product_id, sales_qty from table_a
union all
select product, product_id, sales_qty from table_b
I can run both sql separately, however when I use union all
to combine two result set, I got this error: ORA-12704: character set mismatch
Why's that? And what cause this error
p.s. I have made sure the output columns no. and type are the same