# Retrieve packages in grid error

**URL:** <https://forums.toadworld.com/t/retrieve-packages-in-grid-error/34702>\
**Category:** Toad for Oracle - Beta\
**Created:** [December 20, 2015, 10:22pm UTC](https://forums.toadworld.com/t/retrieve-packages-in-grid-error/34702 "2015-12-20T22:22:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [December 20, 2015, 10:22pm UTC](https://forums.toadworld.com/t/retrieve-packages-in-grid-error/34702/1 "2015-12-20T22:22:04Z")

</div>

HI,

Do not know since when is this code (saw in 12.9.0.9 and 12.9.0.12 x64), but just found out that it is not working on database version:

## BANNER

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production  
PL/SQL Release 11.1.0.7.0 - Production  
CORE 11.1.0.7.0 Production  
TNS for HPUX: Version 11.1.0.7.0 - Production  
NLSRTL Version 11.1.0.7.0 - Production

Problem is in generated code that display packages:

with PACKAGES as  
(Select :own owner, object\_name, object\_type, decode(status, ‘VALID’, ‘V’, ‘I’) status, last\_ddl\_time, object\_id, created  
from sys.user\_objects  
where 1=1  
and object\_type in (‘PACKAGE’, ‘PACKAGE BODY’))  
SELECT PACKAGES.owner, PACKAGES.object\_name, PACKAGES.object\_type, PACKAGES.status,  
PACKAGES.last\_ddl\_time, PACKAGES.object\_id, PACKAGES.created  
,NVL(pi.AUTHID, ‘DEFINER’) AUTHID  
,NVL(d.debuginfo, ‘F’) DEBUGINFO  
FROM PACKAGES  
,(SELECT object\_id, authid  
FROM sys.user\_procedures  
WHERE subprogram\_id = 0  
AND object\_type = ‘PACKAGE’  
GROUP BY object\_id, authid) pi  
, sys.all\_probe\_objects d  
WHERE PACKAGES.object\_id = pi.object\_id (+)  
AND d.object\_id (+) = PACKAGES.object\_id  
AND d.owner (+) = PACKAGES.object\_name  
AND d.object\_name (+) = PACKAGES.object\_name  
AND d.object\_type **(+) in** (‘PACKAGE’, ‘PACKAGE BODY’)  
order by 3, 2

which is causing error:

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

Same code is working on 11.2.0.3 database.  
Brg  
Damir

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 28, 2015, 5:55am UTC](https://forums.toadworld.com/t/retrieve-packages-in-grid-error/34702/2 "2015-12-28T05:55:20Z")

</div>

It’s been fixed for the next beta.