SQL Language (MOSC)

MOSC Banner

patch for bug 5397515 or alternate for query please

edited Sep 20, 2010 10:00PM in SQL Language (MOSC) 16 commentsAnswered

Hi

I am running following query on 10.2.0.3 but giving me internal error. Came to know that its a bug 5397515 fixed in 10.2.0.4. I want to know is there any patch available to resolve just this bug without shifting to 10.2.0.4. or any alternate for this query please??

SELECT AB.SHIPMENT_LINE_ID, AB.TRANSACTION_ID

  FROM RCV_TRANSACTIONS AB

 WHERE AB.TRANSACTION_TYPE = 'RECEIVE'

   AND AB.SHIPMENT_LINE_ID NOT IN

       (select

             RTS.SHIPMENT_LINE_ID              

          from RCV_TRANSACTIONS RTS

       

         WHERE (LEVEL = 2 OR

               LEVEL =

               (                

                 select MAX(LEVEL)

                   from RCV_TRANSACTIONS B

                  start with B.TRANSACTION_ID = 133847

                 connect by PRIOR B.TRANSACTION_ID = B.PARENT_TRANSACTION_ID))

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