DBD::Oracle: Synonym translation no longer valid?

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

Re: DBD::Oracle: Synonym translation no longer valid?

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 =20
longer exists.

Action: Replace the synonym with the name of the object it references =20
or re-create the synonym so that it refers to a valid table, view, or =20
synonym.


HTH
Michael


Quoting Robert Hicks :

> 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 =3D msf829.EMPLOYEE_ID AND msf829.PHYSICAL_LOC =3D
> NGXREFPHYL.PHYSICAL_LOC AND msf810.SURNAM
> E !=3D 'ADMIN' AND msf810.SURNAME !=3D 'ICGS' AND msf810.SURNAME !=3D
> '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 =3D msf829.EMPLOYE
> E_ID AND msf829.PHYSICAL_LOC =3D NGXREFPHYL.PHYSICAL_LOC AND
> msf810.SURNAME !=3D 'ADMIN' AND msf810.SURN
> AME !=3D 'ICGS' AND msf810.SURNAME !=3D 'CONVERSION' ORDER BY msf810.SURNA=
ME
> "] at D:\Projects\Perl\XLReports\get_primaries.pl line 31.
>
> What is synonym translation???
>
> Robert

Re: DBD::Oracle: Synonym translation no longer valid?

Michael Garfield Sørensen, CeDeT wrote:
> 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
>
>

OMG, they changed the table name without telling me! Nice of them.

It helped a lot.

Robert