Home » SQL & PL/SQL » SQL & PL/SQL » Not able to see package body only able to see specfication (sql developer, XP)
icon3.gif  Not able to see package body only able to see specfication [message #431693] Thu, 19 November 2009 03:00 Go to next message
satyam.sumit
Messages: 7
Registered: October 2009
Location: INDIA
Junior Member

Please suggest.

i have created a package in a different schema & givem execute grant to it.Not able to see package body only able to see specfication.
Re: Not able to see package body only able to see specfication [message #431694 is a reply to message #431693] Thu, 19 November 2009 03:03 Go to previous messageGo to next message
ThomasG
Messages: 3185
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
What do you mean by "see"?

Of course, you can only *execute* the public functions and procedures of the package, not the private ones.
Re: Not able to see package body only able to see specfication [message #431700 is a reply to message #431693] Thu, 19 November 2009 03:31 Go to previous message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No you can't unless you have DBA privileges or write a procedure that shows it to you.

Regards
Michel
Previous Topic: Statistics time determination
Next Topic: PL/SQL - Passing PARAMETER as a TABLE
Goto Forum:
  


Current Time: Wed Sep 28 00:39:41 CDT 2016

Total time taken to generate the page: 0.06810 seconds