My Oracle Support Banner

DG4DRDA Gives Errors Ora-2070 When Issuing Updates or Ora-1722 For Selects With Numeric Binds (Doc ID 1062700.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms



After upgrade of  TG4DRDA from 10.2 to Database Gateway for DRDA (DG4DRDA) 11.1 or 11.2 selects work successfully but updates give the error -

ORA-02070: database <db_link_name> does not support TO_NUMBER in this context


Using the DG4DRDA 11.2 can give an ORA-1722 error when a select is made using numeric binds -


variable B2 number;
exec :B2:=12;

select * from test.employee@dg4drda where EDLEVEL =:b2 ;

select * from test.employee@dg4drda where EDLEVEL =:b2
*
ERROR at line 1:
ORA-01722: invalid number



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.