Print Thread
PSD Cannot access package body...
#63954 05/27/22 11:54 AM
Joined: Sep 2008
Posts: 143
Ireland
W
WexSoft Offline OP
Member
OP Offline
Member
W
Joined: Sep 2008
Posts: 143
Ireland
I am using PSD v15.0.0.2050, 64-bit. When I try to view package body I'm getting /* Source of PACKAGE BODY MILK.GM_EXT is not available */, but when logged into the same database as the same user using SQL Developer I can access the package body. See both screen shots attached.

Attached Files
PSD_Cannot_Access_Package_Body.jpg (36.2 KB, 38 downloads)
SQD_Can_Access_Package_Body.jpg (100.23 KB, 37 downloads)
Re: PSD Cannot access package body...
WexSoft #63957 05/27/22 01:53 PM
Joined: Sep 2008
Posts: 143
Ireland
W
WexSoft Offline OP
Member
OP Offline
Member
W
Joined: Sep 2008
Posts: 143
Ireland
Just one point of clarification - the issue arises when I am logged in as a user other than the package owner. If I log in as the package owner, the package body is visible. Is there a security setting that PL/SQL Developer is obeying that SQL Developer is not?

Re: PSD Cannot access package body...
WexSoft #63959 05/27/22 02:18 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Perhaps you need to enable the "Use DBA views if available" option from the Oracle > Options preference page? Now PL/SQL Developer will use the sys.dba_objects, sys.dba_source, etc views instead of the "sys.all_xxxx" versions.

You will need to restart PL/SQL Developer before this preference change takes effect.


Marco Kalter
Allround Automations
Re: PSD Cannot access package body...
WexSoft #63972 06/03/22 11:30 AM
Joined: Sep 2008
Posts: 143
Ireland
W
WexSoft Offline OP
Member
OP Offline
Member
W
Joined: Sep 2008
Posts: 143
Ireland
Thanks Marco, that option was already ticked, but I played around with a few other settings, shut down PSD and started it up again, and now it's working fine - I cannot recreate the issue no matter what settings I apply. So you can ignore this issue, unless it recurs.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.032s Queries: 15 (0.011s) Memory: 2.5130 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-18 14:47:59 UTC
Valid HTML 5 and Valid CSS