46.27 EXPORT_USERS Procedure

This procedure produces an export file of the current workspace definition, workspace users, and workspace groups when called from a page. To execute this procedure, the current user must have administrative privilege in the workspace.

Syntax

APEX_UTIL.EXPORT_USERS (
    p_export_format     IN VARCHAR2 DEFAULT 'UNIX' );

Parameters

Table 46-25 EXPORT_USERS Parameters

Parameter	Description
p_export_format	Indicates how rows in the export file are formatted. Specify UNIX to have the resulting file contain rows delimited by line feeds. Specify DOS to have the resulting file contain rows delimited by carriage returns and line feeds.

Example

The following example calls this procedure from a page to produce an export file containing the current workspace definition, list of workspace users, and list of workspace groups. The file is formatted with rows delimited by line feeds.

BEGIN
    APEX_UTIL.EXPORT_USERS;
END;