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”