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: 64153
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: page heading in addition to column headings
Next Topic: SMTP permanent error: 500 #5.5.1
Goto Forum:
  


Current Time: Sun Dec 11 06:33:59 CST 2016

Total time taken to generate the page: 0.07383 seconds