Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 15 of 30
To remove a standalone stored procedure from the database. Do not use this statement to remove a procedure that is part of a package. Instead, either drop the entire package using the DROP
PACKAGE
statement, or redefine the package without the procedure using the CREATE
PACKAGE
statement with the OR
REPLACE
clause.
For information on creating a procedure, see "CREATE PROCEDURE".
The procedure must be in your own schema or you must have the DROP
ANY
PROCEDURE
system privilege.
schema |
is the schema containing the procedure. If you omit schema, Oracle assumes the procedure is in your own schema. |
procedure |
is the name of the procedure to be dropped. When you drop a procedure, Oracle invalidates any local objects that depend upon the dropped procedure. If you subsequently reference one of these objects, Oracle tries to recompile the object and returns an error message if you have not re-created the dropped procedure. For information on how Oracle maintains dependencies among schema objects, including remote objects, see Oracle8i Concepts. |
The following statement drops the procedure TRANSFER
owned by the user KERNER
and invalidates all objects that depend upon TRANSFER
:
DROP PROCEDURE kerner.transfer
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|