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
Messages: 22
Registered: April 2007
Location: chennai
Junior Member
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: 63945
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.

Previous Topic: page heading in addition to column headings
Next Topic: SMTP permanent error: 500 #5.5.1
Goto Forum:

Current Time: Fri Oct 28 04:04:47 CDT 2016

Total time taken to generate the page: 0.11033 seconds