The manual (Oracle9i Database Error Messages) says: ORA-00980 synonym translation is no longer valid
Cause: The synonym used is based on a table, view, or synonym that no longer exists.
Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.
HTH Michael Quoting Robert Hicks <[EMAIL PROTECTED]>:
DBD::Oracle::db prepare failed: ORA-00980: synonym translation is no longer valid (DBD ERROR: error possibly near <*> indicator at char 129 in 'SELECT msf810.SURNAME, msf810.FIRST_NAME, msf829.EMPLOYE E_ID, msf829.PHYSICAL_LOC, NGXREFPHYL.DISTRICT_CODE FROM msf810, msf829, <*>NGXREFPHYL WHERE msf810. EMPLOYEE_ID = msf829.EMPLOYEE_ID AND msf829.PHYSICAL_LOC = NGXREFPHYL.PHYSICAL_LOC AND msf810.SURNAM E != 'ADMIN' AND msf810.SURNAME != 'ICGS' AND msf810.SURNAME != 'CONVERSION' ORDER BY msf810.SURNAME ') [for Statement "SELECT msf810.SURNAME, msf810.FIRST_NAME, msf829.EMPLOYEE_ID, msf829.PHYSICAL_LOC , NGXREFPHYL.DISTRICT_CODE FROM msf810, msf829, NGXREFPHYL WHERE msf810.EMPLOYEE_ID = msf829.EMPLOYE E_ID AND msf829.PHYSICAL_LOC = NGXREFPHYL.PHYSICAL_LOC AND msf810.SURNAME != 'ADMIN' AND msf810.SURN AME != 'ICGS' AND msf810.SURNAME != 'CONVERSION' ORDER BY msf810.SURNAME "] at D:\Projects\Perl\XLReports\get_primaries.pl line 31. What is synonym translation??? Robert
