| disable procedure [message #364392] |
Mon, 08 December 2008 04:41  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
