Re: Stored procedure compilation problem

kglr.sql is an an old name for what is now called catrpc.sql - which is located in $ORACLE_HOME/rdbms/admin. Guess they haven't changed the code in the error handlers.

It's supposed to be run from catproc.sql when the database is created. You could try running it again, but the objects it creates are likely already there, for the reason just stated.

As others have already said, it's most probably a problem between Jdeveloper and the database. Jdeveloper 9i is certified for use against   8.1.7.4 databases (not that that means it will *always* work correctly, but your chances are better), which would likely fix little problems like this.

Cheers,

td

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
Received on Wed Jun 30 2004 - 18:24:16 CDT