I configured "procedure.res.preHook" in ORDS. It works fine for the REST APIs I have develop, but SQLDeveloper Web will no longer load.
I get lots of the following in the ORDS Logs:
PLS-00201: identifier 'APPS.XXAZZ_ORDS_PK' must be declared
ORA-06550: line 21, column 3:
PL/SQL: Statement ignored
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
... 121 more
2024-10-03T22:45:23.798Z SEVERE <oMh2JDVtvAITY1w_qVgyQg> GET dev-apps.azz.com /ords/_sdw/css/images/sqldev_128x128x32.png 503 The request could not be processed because the database stored function pre-hook associated with this resource could not be invoked
ServiceUnavailableException [statusCode=503, logLevel=SEVERE, reasons=[The request could not be processed because the database stored function pre-hook associated with this resource could not be invoked]]
Versions
ORDS: 24.2.3.r2011847
Database: 19c