My Oracle Support Banner

500 Internal Server Error / PLS-00302 After Upgrade To ORDS 22.x Version When Executing Stored Procedure Via Synonym and Database Schema and Objects (Package, Public Synonym) Have The Same Name (Doc ID 2918161.1)

Last updated on DECEMBER 27, 2022

Applies to:

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

Symptoms

After upgrading from ORDS 21.4 to ORDS 22, getting "500 Internal Server Error" (and PLS-00302: component '<>' must be declared) when running a plsql application. The error occurs when executing a stored procedure via a synonym.

Note:
The database package name, schema name and public SYNONYM name are the same.

Changes

 Upgraded from ORDS 21.4 to 22.2.

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.