Re: Stored procedure compilation problem

On 29 Jun 2004 13:38:53 -0700, patrick_hutchison_at_hotmail.com (Patrick Hutchison) wrote:

>comp.databases.oracle.server
>
>Hey guys,
>
>We recently moved two of our database servers to different boxes. We
>have also set up "Oracle Names Servers" in addition to our standard
>local TNS entries. Our local machines are set to check the ONS first
>and then the local TNS settings next. And for the record, we are
>using Release 8.1.7.0.0.
>
>Even though we are using Oracle 8i rather than 9i, I have always been
>able to use Oracle9i JDeveloper successfully. Since the database
>transitions, I've recently tried to create stored procedures involving
>database links, and they will not compile through JDeveloper. But
>interestingly enough, they WILL compile through SQL Plus. But the
>errors that I'm getting in JDeveloper are:
>ORA-04052: error occurred when looking up remote object
>ORA-00604: error occurred at recursive SQL level 1
>ORA-01891: Datetime/Interval internal error
>
>The suggestive action for the ORA-04052 error is:
>"Fix the error. Make sure the remote database system has run KGLR.SQL
>to create necessary views used for querying/looking up objects stored
>in the database."
>
>The KGLR.SQL script is not anywhere to be found on the servers. Does
>something on the servers need to be reconfigured/reinstalled?
>
>The database links are currently set to public, but I have a feeling
>that there is still a privilege problem, a problem with the Oracle
>Names Servers, and/or the TNS files. I also should mention that the
>TNS files on the servers do contain the appropriate domain and SID
>settings for the "linked" servers that I am attempting to query.
>
>I apologize in advance if I'm using incorrect terminology and/or
>confusing the hell out of everyone, but database administration is
>COMPLETELY new to me (I'm a developer).
>
>I would greatly appreciate any help you may be able to provide!
>
>Thanks,
>Pat

You need to resolve ora-1891 not ora-4052. And without seeing more details like the code and the database link set up and tnsnames.ora your lengthy post just boils down to 'it doesn't work' and you leave the group shoot in the dark, using the crystall balls we don't have.

--
Sybrand Bakker, Senior Oracle DBA