ORA-28500 Using DG4MSQL 11.2.0.3 With a Procedure That Inserts Values That Join 2 NVL Variables
(Doc ID 1513679.1)
Last updated on SEPTEMBER 20, 2021
Applies to:
Oracle Database Gateway for SQL Server - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.
Symptoms
A PL/SQL procedure that uses the Database Gateway for SQL*Server (Dg4MSQL) 11.2.0.3 to make an insert with a join of 2 NVL variables gives the following error -
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from DG4MSQL
ORA-06512: at line 5
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from DG4MSQL
ORA-06512: at line 5
A simple example is -
1. Create a test table in SQL*Server using DBMS_HS_PASSTHROUGH -
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 |