Close

Procedure

Closes an open log file, writing a final message

UTL_FILE.FILE_TYPE/ NVARCHAR(255)

The log file handle, returned closed

Open

Procedure

Opens a log file, writing an initial message

UTL_FILE.FILE_TYPE/ NVARCHAR(255)

The returned open log file handle

VARCHAR2/ NVARCHAR(255)

Optional file prefix. Defaults to 'iConsole_Search_'

VARCHAR2/ NVARCHAR(255)

Optional directory to store the log file.

(Oracle: Name of a DIRECTORY object. Defaults to 'WGNWC_LOG_DIR')

(MSSQL: Directory path. Defaults to 'C:\temp')

Write

Procedure

Writes a message to the log file.

UTL_FILE.FILE_TYPE/NVARCHAR(255)

The log file handle

VARCHAR2/ NVARCHAR(4000)

The message string