Toad World® Forums

package body, wherefore art though

Loaded up the beta. Can’t see the package bodies in the SB LHS. Looks “normal” in 12.11,. but in 12.12.0.2, 64-bit, no bodies. Load body/both are grayed out.

Chris Johnson

IT Systems Analyst

Distribution Logistics

615-855-4371

FWIW, I can see clearly now (the rain is gone…) in 12.12.0.3, 64-bit. Maybe it was fixed in this last release today?

Rich

For me, they are still missing like Chris described, in 12.12.0.3 64-bit.

Best regards,

Niels

Agreed. Still missing.

From: Niels Bache [mailto:bounce-nbache@toadworld.com]

Sent: Friday, July 21, 2017 6:27 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] package body, wherefore art though

External Sender

RE: package body, wherefore art though

Reply by Niels Bache

For me, they are still missing like Chris described, in 12.12.0.3 64-bit.

Best regards,

Niels

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Interesting - I can see package bodies as well in both 32 and 64. I’ve logged this for the developer tho and he’ll be back on Tuesday.

The query to load packages can change quite a bit due to your privileges in the database, and I made some changes in 12.12 to improve query performance. In doing so I probably broke it for your set of privileges. Can you give me a spool SQL doing the same thing from 12.11 and 12.12, where you don’t see package bodies?

Thanks.

12.12.0.4 – no bodies


– Session: DG_ABPPTM@QTMS.WORLD

– Timestamp: 13:08:50.481

Select username

from sys.DBA_USERS a

where exists (select owner

          from   sys.DBA_OBJECTS

          where  owner = a.username)

order by username;


– Session: DG_ABPPTM@QTMS.WORLD

– Timestamp: 13:08:51.669

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   DISTINCT object_id, nvl(authid, 'DEFINER') authid

     FROM     sys.user_procedures

     WHERE    object_type = 'PACKAGE') pi

   ,(SELECT debuginfo, object_id

     FROM   sys.all_probe_objects

     WHERE  owner = :own

     AND    object_type in ('PACKAGE', 'PACKAGE BODY')) d

WHERE PACKAGES.object_id = pi.object_id

AND d.object_id (+) = PACKAGES.object_id

order by 3, 2;

:own(VARCHAR[9],IN/OUT)=‘DG_ABPPTM’

12.11.0.95 bodies visible


– Session: DG_ABPPTM@QTMS.WORLD

– Timestamp: 13:10:39.013

Select username

from sys.DBA_USERS a

where exists (select owner

          from   sys.DBA_OBJECTS

          where  owner = a.username)

order by username;


– Session: DG_ABPPTM@QTMS.WORLD

– Timestamp: 13:10:40.199

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.owner

order by 3, 2;

:own(VARCHAR[9],IN/OUT)=‘DG_ABPPTM’

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Tuesday, July 25, 2017 9:11 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] package body, wherefore art though

External Sender

RE: package body, wherefore art though

Reply by John Dorlon

The query to load packages can change quite a bit due to your privileges in the database, and I made some changes in 12.12 to improve query performance. In doing so I probably broke it for your set of privileges. Can you give me a spool SQL doing the same thing from 12.11 and 12.12, where you don’t see package bodies?

Thanks.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Package Bodies, to Packages, next beta: “I’m with you fellas”