My Oracle Support Banner

Error ORDS-22001 Procedure Name Could Not be Accessed When There Exists Any Object of Same Name and SCHEMA Name (Doc ID 3063085.1)

Last updated on DECEMBER 11, 2024

Applies to:

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

Symptoms

 Run a URL as http://<host>:<port>/ords/<pool name>/<package>.<procedure>

Error appears as

Error code ORDS-22001
The procedure named <package>.<procedure> could not be accessed, it may not be
declared, or the user executing this request may not have been granted execute privilege
on the procedure, or a function specified by security.requestValidation Function
configuration property has prevented access. Check the spelling of the procedure, check
that the execute privilege has been granted to the caller and check the configured
security.requestValidation Function function. If using the PL/SQL Gateway Procedure Allow
List, check that the procedure has been allowed via
ords_admin.add_plsql_gateway_procedure.

 

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
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.