Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 5 of 30
To remove a standalone stored function from the database. For information on creating a function, see "CREATE FUNCTION".
The function must be in your own schema or you must have the DROP
ANY
PROCEDURE
system privilege.
schema |
is the schema containing the function. If you omit schema, Oracle assumes the function is in your own schema. |
function_name |
is the name of the function to be dropped. Oracle invalidates any local objects that depend on, or call, the dropped function. If you subsequently reference one of these objects, Oracle tries to recompile the object and returns an error if you have not re-created the dropped function. See Also: Oracle8i Concepts for more information on how Oracle maintains dependencies among schema objects, including remote objects. |
|
If any statistics types are associated with the function, Oracle disassociates the statistics types with the See Also: "ASSOCIATE STATISTICS" and "DISASSOCIATE STATISTICS" for more information on statistics type associations. |
The following statement drops the function NEW_ACCT
in the schema RIDDLEY
and invalidates all objects that depend upon NEW_ACCT
:
DROP FUNCTION riddley.new_acct;
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|