Removing Subprograms

Contact Us or call 1-877-932-8228
Removing Subprograms

Removing Subprograms

If a subprogram is no longer in direct use and is also not being used by any dependent PL/SQL objects or external programs, it can be removed from the database altogether. Depending upon the configuration of your database, the object might be available to be recovered from the recycle bin (as of Oracle 10g). However, once the recycle bin has been purged, the object is no longer available within the database itself.

Code Sample:

Stored-Procedures-and-Functions/Demos/proc_drop_hello_world.sql
drop procedure test1;

Code Explanation

A stored procedure (or other subprogram) can be dropped using the DROP keyword. Thus the CREATE and DROP keywords that are used to make and remove tables also are used when working with subprograms.

Next