lobinyc.blogg.se

You can specify each parameter only once in each statement. The parameters you can specify in this clause are PLSQL_OPTIMIZE_LEVEL, PLSQL_CODE_TYPE, PLSQL_DEBUG, PLSQL_WARNINGS, and NLS_LENGTH_SEMANTICS. Use this clause to specify a value for one of the PL/SQL compiler parameters.

See Also: Oracle Database Application Developer's Guide - Fundamentals for information on debugging procedures To avoid this process, specify the REUSE SETTINGS clause. You can see the associated compiler error messages with the SQL*Plus command SHOW ERRORS.ĭuring recompilation, Oracle Database drops all persistent compiler switch settings, retrieves them again from the session, and stores them at the end of compilation. If recompiling the procedure results in compilation errors, then Oracle Database returns an error and the procedure remains invalid. If Oracle Database recompiles the procedure successfully, then the procedure becomes valid. Oracle Database also invalidates any local objects that depend upon the procedure, such as procedures that call the recompiled procedure or package bodies that define procedures that call the recompiled procedure. Oracle Database first recompiles objects upon which the procedure depends, if any of those objects are invalid. Oracle Database recompiles the procedure regardless of whether it is valid or invalid. Specify COMPILE to recompile the procedure. Specify the name of the procedure to be recompiled. If you omit schema, then Oracle Database assumes the procedure is in your own schema. Specify the schema containing the procedure.

The procedure must be in your own schema or you must have ALTER ANY PROCEDURE system privilege.ĭescription of the illustration alter_procedure.gifĭescription of the illustration compiler_parameters_clause.gif Please refer to ALTER FUNCTION for more information.

The ALTER PROCEDURE statement is quite similar to the ALTER FUNCTION statement. To redeclare or redefine a procedure, use the CREATE PROCEDURE statement with the OR REPLACE clause (see CREATE PROCEDURE ). This statement does not change the declaration or definition of an existing procedure.