@@@@Dear all,
we have upgraded our two node RAC Database from 10.2.0.4 to 11.2.4.0 on sun SPARC 64 bit for testing purposes before doing it on production.
after upgradation we had multiple issues like AMBIGUITY ERROR (which we already resolved after raising an SR).
Now we have started getting
ORA-00932 : Inconsistent datatypes: expected - got CLOB
in multiple proc scripts which made them invalid.
we have already raised an SR for the SAME but no luck so far.
below is the CODE of a PROC we are facing the issue.
{code}
select CoverNote, count(distinct PolicyInfo) =====> error is coming here
into l_CN, l_ChangeCnt
from (SELECT g.num_covernote_no CoverNote,
g.num_reference_number RenNo,
wmsys.wm_concat(g.TXT_CUSTOMER_NAME ||
g.num_total_premium || r.INFORMATION1 ||
r.INFORMATION2) PolicyInfo
FROM gen_prop_information_tab g,
risk_details r,
cnfgtr_d_all_transactions t
WHERE R.REFERENCE_NUM = g.num_reference_number
and R.REFERENCE_DATE = g.dat_reference_date
and g.num_reference_number = t.trans_id
and g.dat_reference_date = t.trans_date
AND G.NUM_PRODUCT_CODE = '2952'
and g.num_covernote_no = l_CN
and g.num_reference_number >= l_Last_RefNo
group by g.num_covernote_no, g.num_reference_number
order by r.policy_risk_serial, r.risk_detail_serial) Ref
group by CoverNote;
{/code}
what could be the compatibility issue? the same is running fine in 10.2.0.4.
thnks to all