Re: ORA-00922 Selecting on remote db

MarkP28665 wrote:

> croc_at_iname.com >>
> ERROR at line 1:
> ORA-04052: error occurred when looking up remote object
> APPS.GL_CODE_COMBINATIONS_at_PROD.WORLD
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00922: missing or invalid option
> ORA-02063: preceding line from PROD
> <<
>
> I am not sure of your problem, but I noticed that you created a private
> database link. This means that the only authorized user from any database must
> be using the same Oracle user account with the same Oracle password or the
> link will fail. Most of my problems with dblinks have involved security and
> public vs private so I though I would mention this.
>
> The only other idea I have is to check for each object referenced in the pl/sql
> for proper synonyms on the remote locations.
>
> Good luck.
>
> Mark Powell -- Oracle 7 Certified DBA
> - The only advise that counts is the advise that you follow so follow your own
> advise -

  Anytime I see an ORA-00922 error, I start looking for forbidden characters either in the database, or
in hunk of PL/SQL code or being passed as a parameter.

Steve Leatherman
sll_at_aps.anl.gov Received on Mon Dec 22 1997 - 00:00:00 CST