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