ORA-01719: outer join operator (+) not allowed (works on one db, but, not another?) version 9.2.0.6

Hello all,

 I've got a perplexing problem, and am stumped. I've  got 2 databases...both are same version of 9.2.0.6.  Same patch level.

 One is a dev. version of the prod. database. We just  did a refresh of the dev. from the prod. This one  bit
 of code now works only on prod, but, throws an error  on the dev. database.

 The code is:

 SELECT NVL(SUM(DECODE(t.item_type,'DATA CALL'  ,COUNT(t.id))),0)

            ,NVL(SUM(DECODE(t.item_type,'ACTION  ITEM',COUNT(t.id))),0)

       FROM tasks t,
            assignments a
      WHERE (t.id = a.fk_task_id(+)
             AND  t.fk_assigned_by = 34
             AND  (a.status IS NULL OR a.status IN
 ('COMPLETED')
                   )
             AND t.TASK <> 'ACCEPTED'


            )

         OR
            (t.id = a.fk_task_id(+)
             AND a.fk_assigned_to = 34
             AND a.status IN ('ASSIGNED','IN
 WORK','RETURNED')


            )

      GROUP BY t.item_type

 Thie results in an error on the dev. database of:

 ORA-01719: outer join operator (+) not allowed in  operand of OR or IN

 This doesn't occur on the prod. database. Any  ideas, suggestions or links? From a note I found by Tom Kyte..it indicated that this should have been fixed by version 9i...but, here we are...

 Thanks,

 chilecayenne Received on Tue Jun 21 2005 - 08:32:43 CDT