Hi Connor,
We are also having issues exporting apps with SQLcl, since upgrading to APEX 24.1
I've just given the latest version of SQLcl 24.1 a try, but it does not seem to support the new export options yet.
This document suggests that the API does support the export of Audit Info.
https://docs.oracle.com/en/database/oracle/apex/24.1/aeapi/GET_APPLICATION_Function.html#GUID-A8E626D6-D7DE-4E59-8F90-3666A7A41A87 APEX_EXPORT.GET_APPLICATION (
p_application_id IN NUMBER,
p_type IN t_export_type DEFAULT c_type_application_source,
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,
p_components IN apex_t_varchar2 DEFAULT NULL,
p_with_audit_info IN t_audit_type DEFAULT NULL )
RETURN apex_t_export_files;
May I request a new version of SQLcl to cover this option?
Thanks
Peter.