DROP_DIRECTORY procedure - Drop a directory alias

The DROP_DIRECTORY procedure drops the specified directory alias.

Syntax

Read syntax diagramSkip visual syntax diagramUTL_DIR.DROP_DIRECTORY(alias )

Procedure parameters

alias
An input argument of type VARCHAR(128) that specifies the directory alias.

Authorization

EXECUTE privilege on the UTL_DIR module.

Examples

Drop the specified directory alias.

CALL UTL_DIR.DROP_DIRECTORY('mydir')@

This example results in the following output:

  Return Status = 0