Bugfix Release

2.4.2 (2021-01-05)

• Function BackApp:
  • Fixed: #12 - Identifiers longer then 30 characters - compile error on older DB versions or campatibility settings

Bugfix Release

2.4.1 (2021-01-04)

• Function BackApp:
  • Fixed: #10 - Function BackApp throws ORA-14552 in SQL context when p_data_format is set to 'insert'

Feature Release

2.4.0 (2021-01-03)

• Function BackApp:
  • Improve run performance of generated load scripts for data export format INSERT
  • Generate a deployment script for data export format INSERT
  • Make all base paths configurable - new parameters p_base_path_docs, p_base_path_tests, p_base_path_scripts, p_base_path_script_logs, p_scripts_working_directory

Feature Release

Function BackApp: Rework table data export format INSERT - thanks to Connor McDonald for his blog post Generating INSERT scripts that run fast!

Bugfix & Feature Release

• Function BackApp:
  • Fixed: #4 - plex.backapp throws "ORA-00904: DBMS_JAVA.LONGNAME: invalid identifier" in Oracle instances without a JVM
  • Fixed: #5 - plex.backapp throws "ORA-03113: end-of-file on communication channel" in Oracle 19.6
  • Table data can now be exported in two formats: CSV and INSERT (p_data_format, default is CSV, INSERT is experimental and under development)

Feature Release

• Function BackApp:
  • New parameter to include ORDS modules (p_include_ords_modules)
  • New parameter to remove the outer column list on views, which is added by the compiler (p_object_view_remove_col_list); this was done in the past implicitly and can now be switched off; thanks to twitter.com/JKaschuba for the hint
  • Object DDL: Comments for tables and views are now included
  • Script templates: Improved export speed by using a base64 encoded zip file instead of a global temporary table to unload the files
  • Fixed: Unable to export JAVA objects on systems with 30 character object names; thanks to twitter.com/JKaschuba for the hint
  • Fixed: Views appears two times in resulting collection, each double file is postfixed with "_2" and empty
  • Fixed: Tables and indices of materialized view definitions are exported (should be hidden)
• New function to_base64: convert BLOB into base64 encoded CLOB - this is helpful to download a BLOB file (like a zip file) with SQL*Plus

Bugfix Release

• Fixed: Function BackApp throws error on large APEX UI install files (ORA-06502: PL/SQL: numeric or value error: character string buffer too small)

Bugfix Release

• Fixed: Compile error when DB version is lower then 18.1 (PLS-00306: wrong number or types of arguments in call to 'REC_EXPORT_FILE')

Feature Release

• Package is now independend from APEX to be able to export schema object DDL and table data without an APEX installation
  • ATTENTION: The return type of functions BackApp and Queries_to_CSV has changed from apex_t_export_files to plex.tab_export_files
• New parameters to filter for object types
• New parameters to change base paths for backend, frontend and data

Bugfix Release

• Fix templates: change old parameters in plex.backapp call (p_object_filter_regex, p_data_table_filter_regex) to the new parameters (p_object_name_like, p_object_name_not_like, p_data_table_name_like, p_data_table_name_not_like)
• Add install and uninstall scripts for PLEX itself