Hello,
I appreciate (really I do) that 11.2.0.4 and 12.1.0.2 are old, out of support and should have been replaced some years ago.
I'm trying to at least keep ORDS up to date while progressing with the above.
11.2.0.4 and 12.1.0.2 were supported as target databases for ORDS 24.4, and looking at My Oracle Support certification tab, it looks like they still are with ORDS 25.2. However, on trying to upgrade targets to ORDS 25.2 the OAUTH_INTERNAL package is invalid, e.g. the below from an 11.2.0.4 database.
[*** script: oauth_internal.pls]
Package OAUTH_INTERNAL compiled
LINE/COL ERROR
--------- -------------------------------------------------------------
22/3 PL/SQL: Declaration ignored
22/43 PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal
Errors: check compiler log
At the end of the upgrade process 6 objects are invalid because of the above and the final message is:
ERROR at line 1:
ORA-20006: ERROR: Validating objects failed. ORA-20006: ERROR: ORDS schema database objects contains INVALID status.
ORA-06512: at "ORDS_METADATA.VALIDATE_ORDS", line 474
ORA-06512: at line 3
Please could you confirm whether ORDS 25.2 still supports 11.2.0.4 and 12.1.0.2 and if so whether the above is a known issue etc.
Many thanks
Tim