Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-32582 after upgrade to 11.2.0.4 from 11.2.0.2 PSU11

edited Nov 15, 2013 2:51AM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered
Hi all,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center