CRM On Demand - Administration (MOSC)

MOSC Banner

Missing grants on HTP package after import? - ORA-00980: synonym translation is no longer valid

edited Apr 5, 2016 7:41AM in CRM On Demand - Administration (MOSC) 1 commentAnswered ✓

Oracle 9.2.0.8 on Solaris

Hi,

We get this error for a user after an import in 9i:

When trying to compile a package:

PLS 00201:identifier HTP.PRINT must be declared

PLS 00201:identifier HTP.HTMLOPEN must be declared

How can I grant this to myuser?

grant execute on HTP to myuser;

grant execute on HTP to myuser

                 *

ERROR at line 1:

ORA-00980: synonym translation is no longer valid

Any ideas?

Regards

TLD

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center