What is syntax for dropping a procedure and a function? Are these operations possible?

Q

What is syntax for dropping a procedure and a function? Are these operations possible?

✍: Guest

A

Drop Procedure/Function ; yes, if they are standalone procedures or functions. If they are a part of a package then one have to remove it from the package definition and body and recompile the package.

2011-09-27, 3732👍, 0💬