GATEWAY TG4DB2 GETS ORA-02070 WHEN SQL PROCEDURE USES DB2 RESERVED WORD WITH DB 10.2.0.5
(Doc ID 1261624.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Gateway for DB2 - Version 10.2.0.3 and laterIBM z/OS on System z
Symptoms
Upgraded Oracle Database from 8.1.7.4 to 10.2.0.5.After connecting to the new 10.2.0.5 and then ran SQL below
to execute procedure (mmlabor_STWRoutes_p),
get "ORA-02070: database PDB2 does not support operator 293 in this context"
and procedure could not update across the Gateway (TG4DB2) to DB2.
(STWRoutes.sql)
SET SERVEROUTPUT ON SIZE 1000000
EXEC mmlabor_STWRoutes_p
EXIT
(mmlabor_stwrouting_p)
CREATE OR REPLACE PROCEDURE MMLABOR.mmlabor_STWRoutes_p IS
CURSOR curRecsToProcess IS
Select * from MMEXP_ROUTINGS
Where Plant = '014'
And Status_Flag = 'CR'
Order By Rec_No;
Pieces_Per_hour Number(9,3) := 0;
...
Current_Date Varchar2(26);
...
Changes
Upgraded Oracle Database from 8.1.7.4 to 10.2.0.5.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 |
| Changes |
| Cause |
| Solution |
| References |