GET_DIRECTORY_PATH procedure - Get the path for a directory alias

The GET_DIRECTORY_PATH procedure returns the corresponding path for a directory alias.

Syntax

Read syntax diagramSkip visual syntax diagramUTL_DIR.GET_DIRECTORY_PATH (alias,path)

Procedure parameters

alias
An input argument of type VARCHAR(128) that specifies the directory alias.
path
An output argument of type VARCHAR(1024) that specifies the path that is defined for a directory alias.

Authorization

EXECUTE privilege on the UTL_DIR module.

Examples

Get the path that is defined for a directory alias.

CALL UTL_DIR.GET_DIRECTORY_PATH('mydir', ? )@

This example results in the following output:

  Value of output parameters
  --------------------------
  Parameter Name  : PATH
  Parameter Value : home/rhoda/temp/mydir

  Return Status = 0