GET_APPLICATION Function
This function exports the given application. Optionally, split the application definition into multiple files. The optional p_with_% parameters
can be used to include additional information in the export.
Syntax
function get_application (
p_application_id in number,
p_split in boolean default false,
p_with_date in boolean default false,
p_with_ir_public_reports in boolean default false,
p_with_ir_private_reports in boolean default false,
p_with_ir_notifications in boolean default false,
p_with_translations in boolean default false,
p_with_pkg_app_mapping in boolean default false,
p_with_original_ids in boolean default false,
p_with_no_subscriptions in boolean default false,
p_with_comments in boolean default false,
p_with_supporting_objects in varchar2 default null,
p_with_acl_assignments in boolean default false)
return wwv_flow_t_export_files;
Parameters
Table 15-1 GET_APPLICATION Function Parameters
Parameters | Description |
---|---|
|
The application id. |
|
If |
|
If |
|
If |
|
If |
|
If |
|
If |
|
If |
|
If |
|
If |
|
If |
|
If |
|
If |
RETURNS
A table of apex_t_export_file
. Unless the caller passes p_split=>true
to the function, the result will be a single file.
Example
This sqlplus code fragment spools the definition of application 100 into file f100.sql.
variable name varchar2(255)
variable contents clob
declare
l_files apex_t_export_files;
begin
l_files := apex_export.get_application(p_application_id => 100);
:name := l_files(1).name;
:contents := l_files(1).contents;
end;
/
set feed off echo off head off flush off termout off trimspool on
set long 100000000 longchunksize 32767
col name new_val name
select :name name from sys.dual;
spool &name.
print contents
spool off
Parent topic: APEX_EXPORT