17.4 GET_WORKSPACE Function

This function exports the given workspace's definition and users. The optional p_with_% parameters which all default to false can be used to include additional information in the export.

Syntax

FUNCTION GET_WORKSPACE (
    p_workspace_id          IN NUMBER,
    p_with_date             IN BOOLEAN DEFAULT FALSE,
    p_with_team_development IN BOOLEAN DEFAULT FALSE,
    p_with_misc             IN BOOLEAN DEFAULT FALSE )
    RETURN apex_t_export_files;

Parameters

Table 17-4 GET_WORKSPACE Function Parameters

Parameters	Description
p_workspace_id	The workspace id.
p_with_date	If true, include export date and time in the result.
p_with_team_development	If true, include team development data.
p_with_misc	If true, include data from SQL Workshop, mail logs, etc. in the export.

Returns

A table of apex_t_export_file.

Examples

Export the definition of workspace #12345678.

declare
    l_file apex_t_export_files;
begin
    l_files := apex_export.get_workspace(p_workspace_id => 12345678);
end;