DG4DRDA Gives Errors Ora-2070 When Issuing Updates or Ora-1722 For Selects With Numeric Binds
(Doc ID 1062700.1)
Last updated on FEBRUARY 05, 2019
Applies to:Oracle Database Gateway for DRDA - Version 126.96.36.199 to 188.8.131.52 [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 -
Using the DG4DRDA 11.2 can give an ORA-1722 error when a select is made using numeric binds -
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