ORA-32582 after upgrade to 11.2.0.4 from 11.2.0.2 PSU11
We are working on the upgrade to 11.2.0.4 from 11.2.0.2, today we have detected an issue in our business aplication due the following error:
select
xtab.releaseLines
FROM XMLTABLE('sample/Releases/Release'
PASSING xmltype('<sample><Releases><Release AllotmentId="185626"></Release></Releases></sample>')
COLUMNS allotmentId number PATH '@AllotmentId',
releaseLines xmltype PATH '.'
)xtab,
(select null od_stockunitid from dual) cu,
(select 1 XMLUnitid, 2 StockUnitID ,3 Subservice from dual) XML_UNIT
where
XML_UNIT.XMLUnitid (+) = xtab.allotmentId
AND XML_UNIT.StockUnitID = cu.od_stockunitid (+);
who fails in 11.2.0.4 with
ERROR at line 8:
ORA-32582: table function with left correlation to a table cannot also be left outer-joined to the table