Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developer not Loading when Pre-Hook Configured

Jon DixonOct 3 2024

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

This post has been answered by thatJeffSmith-Oracle on Oct 9 2024
Jump to Answer
Comments
Post Details
Added on Oct 3 2024
6 comments
342 views