Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Error while running DBMS_RECTIFIER_DIFF.DIFFERENCES

Error while running DBMS_RECTIFIER_DIFF.DIFFERENCES

From: GUPTA, DEEPENDER <DGUPTA_at_entergy.com>
Date: Thu, 10 Mar 2005 13:06:05 -0600
Message-ID: <E9270A7736A5914C94E0D74EB6A5136103C2E49A@tcbyexs02.ar.entergy.com>


I am using DBMS_RECTIFIER_DIFF.DIFFERENCES to find the data difference between two tables and receiving the following errors. Does anybody know what could be the reason. The structure of both the tables is exactly similar. I am not getting any error when I run the MINUS between two tables... Any suggestions..

DECLARE
*
ERROR at line 1:
ORA-06550: line 1, column 1361:
PL/SQL: ORA-00904: "FLOWGATE_INFO": invalid identifier ORA-06550: line 1, column 1229:
PL/SQL: SQL Statement ignored
ORA-06550: line 1, column 2579:
PL/SQL: ORA-00904: "FLOWGATE_INFO": invalid identifier ORA-06550: line 1, column 1966:
PL/SQL: SQL Statement ignored

ORA-06512: at "SYS.DBMS_RECTIFIER_DIFF", line 1628
ORA-06512: at "SYS.DBMS_RECTIFIER_DIFF", line 1219
ORA-06512: at line 97
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 10 2005 - 14:09:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US