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 MAY 11, 2022

Applies to:

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


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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.