My Oracle Support Banner

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 FEBRUARY 03, 2019

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

 
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


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.