I'm moving a WebLogic/OHS/mod_plsql based application to Tomcat/ORDS (no APEX). The application primarily calls packages in a 19c db.
In the old setup, if there's an error it displays it on the web page, eg. “Failed to execute target procedure ORA-12154: TNS:could not resolve the connect identifier specified", along with the procedure name, parameter list/environment variables. I presume this is controlled by OHS's mod_plsql which has “PlsqlErrorStyle DebugStyle” in the config file dads.conf.
With the same page on ORDS I get a 500 internal server error and the ORA-12154 error output appears in the Tomcat log file.
Pages not generating an error work fine and display identically to the old Weblogic/OHS pages.
So my question is: can I configure ORDS/Tomcat to display debug style error output to the web page rather than throwing a 500 error? ORDS (not Tomcat) is generating the error text as the error shows the ORDS logo and error format.
Apologies if this an FAQ, I couldn't find an answer when searching.