OraTAPI v1.6.4

This fixes the automanaged columns issue, where p_row signature types, tried to update the "created by"/"created on" columns. Typically this might results in a not null constraint violation.

You can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.7.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

OraTAPI 1.6.2

Updates:

1. Added thick client support. Connection via LDAP or Wallets is only supported via thick client. To configure thick client, either:

• Download and place the basic Oracle Instant Client in an oracle_client folder, in the root OraTAPI directory.
• Set and export the ORACLE_IC_HOME shell variable, to point to the Instant Client location.

2. Fix the issue where the primary key column(s) were not the first columns in the table. This broke the generation of the signature of delete APIs, causing a leading comma on the first parameter specification.

3. Fixes the issue where logger templates are always setting the procedure name to 'del'. Note you will also need to modify your templates/packages/procedures templates. Previously each template had a unique substitution placeholder for the procedure, e.g. %insert_procname%. For older formats, you need to edit the files and change this to %procname%.

You can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.7.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

Version OraTAPI v1.5.9

This has 2 minor logger related bug fixes.

1. Issue where 'del' was always assigned to the l_scope;
2. Duplicate updates in the logger elated upsert templates.

In respect of 2, after applying the update, you won't see a change. This only updates the sample templates which are used to initialise OraTAPI. If you haven't modified the templates you can always use:

cd <path-to-installation-folder>
./bin/quick_config.sh -t liquibase --force

However, if you have modified the templates, you will need to manually edit the upsert.tpt template, located under: OraTAPI/resources/templates/packages/procedures. If affected by this issue, you will see 2 consecutive update statements. Simply remove one of them.

You can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.7.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.7

This is a minor update.

Fix the issue where the primary key column(s) were not the first columns in the table. This broke the generation of the signature of delete APIs, causing a leading comma on the first parameter specification.

You can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.7.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.6

This is a minor update to include changes to the license, granting Oracle Corporation:

1. Use, copy, modify, and fork the OraTAPI codebase internally within Oracle, without the need to comply with the terms of the open source license under which it is
   publicly released (currently MIT).
2. Redistribute internally across Oracle systems, infrastructure, and repositories, without needing to retain open source attribution or license notices.

See ORACLE_INTERNAL_LICENSE.txt

If you are running 1.4.24 or later, you can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.6.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.3

This is a macOS install fix/update:

This fixes a bug with Python11/macOS/Homebrew. This resulted in a setup.sh an error:

Error: This environment is externally managed
╰─> To install Python packages system-wide, try brew install
   xyz, where xyz is the package you are trying to
   install...

If you are running 1.4.24 or later, you can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.3.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.2

This is a minor update:

• Fixes a template bug which impacted logger templates. This causes the delete procedure to be identified as the unit procedure for all types of APIs.

If you are running 1.4.24 or later, you can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.2.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.1

This is a minor update:

• Add OraTAPI.ini control for skipping tables (with warning) which have no primary key.
• Perform a table count check against the table owner schema. If there are no tables, we now error and exit.
• Improve exception handling when mandatory parameter combinations are omitted. (now user friendly).
• Refined sample OraTAPI.ini
• Added a unit test sample OraTAPI.ini (resources/config/samples/OraTAPI.ini.ut.sample)

If you are running 1.4.24 or later, you can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.1.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.4.34

This update is to the utPLSQL template responsible for constraint test (constraint_test.common.sample file). This was an adjustment relating to utPLSQL test generation.

Once you have applied the update:

If you have not modified your templates, simply reinstantiate using bin/quick_config -f -t <template-set> -T. Replace <template-set>with
whichever template set you are using (basic, liquibase, logger or llogger).

Examples:

• bin/quick_config.sh -f -t llogger -T (Mac/Linux)
• bin\quick_config -f -t llogger -T (Windows).

If you have modified your templates, you'll need to consider a manual copy/paste of the first line of:
resources/templates/ut_packages/body/samples/constraint_test.common.sample
to replace the first line in:
resources/templates/ut_packages/body/constraint_test.tpt

In addition to the above, when using the -s option, update_ora_tapi now provides a preview of the latest version's release notes before prompting for download.

If you are running 1.4.24 or later, you can download and install the latest update using:

• bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
• bin\update_ora_tapi -t <staging_path>(Windows)

Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.4.34.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.4.32

UPDATES:

1. For utPLSQL procedure name generation, where we have a sys generated not null constraint, we now derived the test procedure name, based on the column name: test_<column_name_lc>_not_null. Note that the original Sys generated name, is still included to comments, to avoid confusion.
2. Improved update mechanism - cross-checks of OraTAPI.ini file improved and included to update_ora_tapi.
3. Fixed a problem with logger templates for the append parameters instruction. We now use the explicit primary key column parameters, instead of referencing the pk columns in p_row.

Download the oratapi-1.4.32.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.