Good Morning
We have recently updated to Apex 26.1.1 running on our Oracle 19C database
I was interested to test Apex Lang.
We can Export App's as Apex Lang and As SQL the issue comes when importing,
The SQL import works fine but when importing Apex Lang
It first Asks to to set an ORDS rest Schema where I chose the same schema the workspace is running under
I then get an error
Error Message
1 error has occurred
- ORDS Authentication request failed. Reason: Not Found
This error is consistent now with any Apex Lang Imports
SQL imports are still fine
Can anyone provide any advice on how to resolve this issue, I have scoured the internet looking for a resolution, one did crop up regarding having Catalogue access on the user but this has been checked and is not granted.
08/07/2026 EDIT:- I dont believe the issue below is related to the Apexlang issue as we have been on a different environment and can enable the rest services but still get the Apexlang issue..
07/07/2026 Edit:- I have also noticed that when selecting SQL Workshop - RESTful Services (a feature we have never used) I get the following error - not sure if this also has any bearing on the Apexlang importing issue
ORA-20000: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
Kind Regards
Mark