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
