Home » SQL & PL/SQL » SQL & PL/SQL » disable procedure (oracle 9i)
disable procedure [message #364392] Mon, 08 December 2008 04:41 Go to next message
tamil
Messages: 22
Registered: April 2007
Location: chennai
Junior Member
hi,
i've created one procedure and named as GET_TOT_ED and complied successfully without errors.Then i try to known the status of that particular procedure using user_objects table.
Now i am not using that procedure and how to change the status of valid to invalid.
Re: disable procedure [message #364397 is a reply to message #364392] Mon, 08 December 2008 05:04 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If the procedure is valid you can't change its status to invalid.
If you don't use it, drop it.

Regards
Michel
Previous Topic: change column
Next Topic: how to get the list of tables having referential integrity connection
Goto Forum:
  


Current Time: Thu Aug 24 02:00:15 CDT 2017

Total time taken to generate the page: 0.01844 seconds