My Oracle Support Banner

PLSQL Web Application Unable To Access Over Browser Via ORDS 19.2 (Doc ID 2675923.1)

Last updated on AUGUST 02, 2020

Applies to:

Oracle REST Data Services - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

On : ORDS 19.2 version, mod_pls Issues

PLSQL web application unable run using ORDS under a specific user

 

NOTE: In the  examples below  user/objects details  represent a fictitious sample (based upon made up data used in the Oracle Demos.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

The URL below fails with a 500 Internal Server Error

http://<HOST>:<PORT>/ords/user1/hello

user1 is a db schema that has been mapped in ords and hello is a plsql package contains html and java script code created under user1 db user.


From debug trace log messages are attached for your investigation.

ERROR
-----------------------
HTTP 500 Internal Server error

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.