Re: Stored procedure compilation problem

On 30 Jun 2004 08:01:52 -0700, patrick_hutchison_at_hotmail.com (Patrick Hutchison) wrote:

>Just out of curiosity, how do you know that my problem is with the
>01891 error as opposed to the 04052 one? I'm not doubting you, it's
>just unfamiliar to me as I'm used to debugging onward from the first
>reported error. Oh, I tried to local some information on the 01891
>error and there isn't much out there at all.

ora-604 is a generic message which is always accompanied by a subsequent line with the real problem
From the error text of ora-4052 it appears it is also a generic message followed by a subsequent error stack.

As to your problem, obviously the cause must be hiding in the interaction with Jdeveloper and Oracle. sql*plus is just the most basic interface there is, if it works in sql*plus, it should work everywhere else.

--
Sybrand Bakker, Senior Oracle DBA