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 DECEMBER 14, 2010

Applies to:

Oracle Database Gateway for DB2 - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
IBM 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

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