ora 12704 - character set mismatch when select nvarchar2 column

[Harvinder Singh]

Title: Oracle pricing

Hi,

I have a table t_base_props with 3 columns defined as NVARCHAR2(256).......

 When i try to select directly from table like select nm_display_name from t_base_props.......the query is properly executed....

but when i try to use ncarchar2 columns in follwing query i am getting error ORA-12704: CHARACTER SET MISMATCH:

What might be the reason.....

character set of database is WE8IS08859P1.....

select

t_sub.id_sub,

map.id_po,map.id_pi_instance,map.id_paramtable,

decode(tb_ip.id_prop,NULL,

tb.nm_display_name,tb_ip.nm_display_name) as instance_nm_name,tb_pt.nm_name pt_nm_name,

tb_po.nm_name po_nm_name,

tb_po.nm_display_name po_nm_display_name,

decode(map.id_sub,null,'N','Y') as b_PersonalRate,

map.b_canICB

from t_base_props tb,t_base_props tb_pt,t_base_props tb_po,t_effectivedate te,

t_pi_template,t_sub,t_pl_map map,t_base_props tb_ip

where t_sub.id_acc = 123

and map.id_po = t_sub.id_po

and tb_ip.id_prop = map.id_pi_instance_parent(+)

and

(map.id_sub is NULL or map.id_sub = t_sub.id_sub and map.id_acc = 123) AND

tb.id_prop = map.id_pi_instance AND

tb_pt.id_prop = map.id_paramtable AND

tb_po.id_prop = map.id_po AND

t_pi_template.id_template = map.id_pi_template AND

te.id_eff_date = t_sub.id_eff_date AND

((te.dt_start <= GetUTCDate() AND (GetUTCDate() <= te.dt_end or te.dt_end is null))

OR (GetUTCDate() <= te.dt_start));

Thanks

Harvinder