Link to home
Start Free TrialLog in
Avatar of jeffreyjseaman
jeffreyjseaman

asked on

Oracle PL/SQL Package

I want to create a PL/SQL Pacakge Name. Well the package says that the object exists already. However I know it doesn't exist I dropped the previous package name. I need to keep the same name and it doesn't work.

How can I find this object and get rid of it? I tried dropping it again and the error message was that the object doesn't exist.

ASKER CERTIFIED SOLUTION
Avatar of Hath1ASC
Hath1ASC

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jeffreyjseaman
jeffreyjseaman

ASKER

Thanks for everyone's support. I ended up figuring it out a different method. But these are good. Thanks for quick response.
See attached.
procedure.txt
Guess I spent too much time testing :-)
Are you willing to share the solution you actually used with us?  It may be helpful to others in the future that find themselves in a similar situation.