Wie importiert man mit SQL*Plus APEX-Anwendungen?

Es muss mindestens die "Workspace ID" gesetzt werden, siehe folgender Beispielcode:

declare
    c_workspace             constant apex_workspaces.workspace%type         := 'MYWS';
    c_app_id                constant apex_applications.application_id%type  := 12345;
    c_app_alias             constant apex_applications.alias%type           := 'MYDEMO';

    l_workspace_id          apex_workspaces.workspace_id%type;
begin
    apex_application_install.clear_all;

    select workspace_id
    into l_workspace_id
    from apex_workspaces
    where workspace = c_workspace;

    apex_application_install.set_workspace_id(l_workspace_id);
    apex_application_install.set_application_id(c_app_id);
    apex_application_install.generate_offset;
end;
/

@MYAPP.sql

Import Script Examples 22.1