I have an error while working with DB links.The db link is looking at
FS system from HR system. It It is working fine in one instance.
It is not working and getting error (ORA-03106: fatal two-task
communication protocol error) on other instance.
Anybody have any Idea???
This is the equivalent sql which i wrote in PeopleSoft SQR
SELECT Chk_pyd.XX_WARRANT_AMT from PS_XX_FA_WARR_ACT@FSDEV Chk_pyd
where Chk_pyd.FISCAL_YEAR = '2004'
and Chk_pyd.XX_COLLEGE IN ('C','F')
and Chk_pyd.XX_FUND = 'H1'
and Chk_pyd.XX_warrant_dt < sysdate