Skip to content

Latest commit

 

History

History
80 lines (54 loc) · 3.62 KB

CHANGELOG.md

File metadata and controls

80 lines (54 loc) · 3.62 KB
Raw

Changelog

2.4.2 (2021-01-05)

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

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'

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

2.3.0 (2020-11-29)

2.2.0 (2020-10-25)

  • 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)

2.1.0 (2019-12-30)

  • 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

2.0.2 (2019-08-16)

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

2.0.1 (2019-07-09)

  • 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')

2.0.0 (2019-06-20)

  • 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
  • Function BackApp:
    • New parameters to filter for object types
    • New parameters to change base paths for backend, frontend and data

1.2.1 (2019-03-13)

  • Fixed: Script templates for function BackApp used old/invalid parameters
  • Add install and uninstall scripts for PLEX itself

1.2.0 (2018-10-31)

  • Function BackApp:
    • All like/not like parameters are now translated internally with the escape character set to backslash like so ... like 'YourExpression' escape '\'
  • Function Queries_to_CSV:
    • Binary data type columns (raw, long_raw, blob, bfile) should no longer break the export

1.1.0 (2018-09-23)

  • Function BackApp:
    • Change filter parameter from regular expression to list of like expressions for easier handling

1.0.0 (2018-08-26)

  • First public release