ORA-04023 ERROR: PUBLIC.DBMS_HS_PASSTHROUGH@Dblink Could Not Be Validated Or Authorized When Used With a Gateway
(Doc ID 1508100.1)
Last updated on JANUARY 18, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.1 to 11.2]
Information in this document applies to any platform.
You are using DG4ODBC 18.104.22.168 to connect to MySQL. A select using the gateway database link is successful from SQLPLUS but trying to compile a PL/SQL package that uses DBMS_HS_PASSTHROUGH or run from SQLPLUS gives the error ORA-04023.
For example -
2 l_Result INTEGER;
4 l_Result := DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@mysql('CALL TEST');
ERROR at line 1:
ORA-04023: Object PUBLIC.DBMS_HS_PASSTHROUGH@MYSQL could not be
validated or authorized
3 l_Result INTEGER;
5 l_Result := DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@mysql('CALL TEST');
Warning: Procedure created with compilation errors.
Show errors will return information similar to -
Error: ORA-04023: Object PUBLIC.DBMS_HS_PASSTHROUGH@MYSQL.DDM001.COM could not be validated or authorized
Text: create or replace procedure test_proc_rem
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|