Print Thread
Problem showing procedures from Wrapped Package in Oracle 11g
#39062 11/18/10 04:06 PM
Joined: Mar 2009
Posts: 32
M
mamv Offline OP
Member
OP Offline
Member
M
Joined: Mar 2009
Posts: 32
Hi Marco,

I'm not being able to see the procedures of some wrapped packages, in the object browser and in code assistant.

Are you aware of any similar problem? I'm able to query all_procedures and all_arguments and see the procedures and arguments of the wrapped package.

I can email you the spec of a wrapped package with this problem.


Thanks in advance,
Manuel Vidigal

Re: Problem showing procedures from Wrapped Package in Oracle 11g
mamv #39065 11/19/10 10:54 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
The elements of a wrapped package will indeed not be visible. PL/SQL Developer parses the PL/SQL code of the package specification to determine the elements, which is not possible when it is wrapped.


Marco Kalter
Allround Automations
Re: Problem showing procedures from Wrapped Package in Oracle 11g
Marco Kalter #39068 11/19/10 11:06 AM
Joined: Mar 2009
Posts: 32
M
mamv Offline OP
Member
OP Offline
Member
M
Joined: Mar 2009
Posts: 32
Thanks for the info Marco.

But it's a major handicap when you use 3rd party software API's which are wrapped in developemnt, because you can't use code assistance to know the name of the procedures and input/output variables. I think it would be a great addon, that when the the package is wrapped to use the info from all_procedure and all_arguments to display this information.

I've checked with ither editors, and while TOAD has the same problem, SQL Navigator displays this info in the browser and in their code assistance.

Could you please add this to the feature requests?


Thanks.

Re: Problem showing procedures from Wrapped Package in Oracle 11g
mamv #39078 11/22/10 10:59 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
Okay, I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

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.085s Queries: 15 (0.059s) Memory: 2.5048 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-30 03:23:43 UTC
Valid HTML 5 and Valid CSS