My Oracle Support Banner

Sql Queries Using LONG Column Types and Oracle Functions Get ORA-2070 Error Using Oracle Gateways (Doc ID 562803.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Database Gateway for Sybase - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Database Gateway for SQL Server - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Oracle Transparent Gateway for Microsoft SQL Server - Version: 10.2.0.6 to 11.2
Oracle Transparent Gateway for IBM DRDA - Version: 10.2.0.1 to 11.2
Oracle Transparent Gateway for Sybase - Version: 10.2.0.1 to 11.2
***Checked for relevance on 09-Dec-2010***


Symptoms


Trying to use any Oracle Gateway any queries which map a foreign table column to an Oracle LONG data type and any Oracle specific function such as CAST, TO_NUMBER, TO_CHAR etc are failing with the following error -

Error received.
"ORA-02070: database XXX does not support XXXX in this context"



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.