ORA-02070: database MYSQLREMOTE does not support in this context
Dear all,
this simple sql also throw error.ORA-02070: database MYSQLREMOTE does not support in this context
destination db is mysql and gateway is 12c.
ORA-02070: database MYSQLREMOTE does not support in this context
Highlighted dated column give error in insert statement to remote db.
Could you please assist me how can insert this value.
EXECUTE IMMEDIATE 'insert into "UML_AUTOSALE_PRODUCT_MASTER"@mysqlremote("CUSTCODE","PRICE_LIST_ID","LONGNAME","SHORTNAME","UNIT","ITMACTIVE","TAXCODE" ,"DATECREATED","RSPAMOUNT","WEIGHTUOM","WEIGHT","USERID","POST_FLAG") |
VALUES (''TUK'','''||prod_rec.list_header_id||''','''||prod_rec.description||''',
'''||prod_rec.segment1||''', '''||prod_rec.product_uom_code||''', |