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 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
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 |