Hi,
I have a table t_base_props with 3 columns defined as
NVARCHAR2(256).......<FONT color=#0000ff
face=Arial>
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
Received on Thu Jul 26 2001 - 10:44:09 CDT
