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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms