Re: Useless error msg

In article <D12trB.388_at_ets.com> user_at_ets.com writes:
> In article <3bki83INNm2d_at_news.ougf.fi> rissahe1_at_news.ougf.fi (Heikki
> Rissanen) writes:
> > Jim Bridges (jbridges_at_cup.hp.com) wrote:
> > : Can anyone shed light on the message from SQLPLUS
 

> > : Warning: Function created with compilation errors.
> >
> >
> > : When I try to create a function. This is one of the most
> > : useless error messages I have ever seen. I am a beginner
> > : at this so I'm sure there is an error somewhere but how to
> > : track it down further?
> >
> > Sorry, I cannot help in this one. But when you use Oracle more, you'll
> > get used to misinformative messages, so be prepared.
> >
> > Regards,
> > Hessu
> >
> > ---------------------------------------------------------------------
> > Heikki Rissanen, United Papermills, Rauma, Finland
> > Email: heikki.rissanen_at_ra.upm.yhtyneet.mailnet.fi
> > ---------------------------------------------------------------------
>
> As the DBA, you can access DBA_ERRORS where owner = 'your_name'. This
 may
> or may not help you for this particular error as it is one of the more
> cryptic Oracle has to offer...
>
> Herman Means
> DBA - ETS, Inc.

This message is just to alert you that errors have been encountered while compiling the function. To display the error(s), you have to select from either DBA_ERRORS,
ALL_ERRORS or USER_ERRORS each of which contain current object errors.

>From USER_ERRORS (when the function was created in the user to which
you're connected)

	SELECT * FROM USER_ERRORS
	WHERE NAME = 'NAME_OF_THE_FUNCTION_IN_UPPERCASE';

FROM DBA_ERRORS or ALL_ERRORS (for other users objects)

	SELECT * FROM DBA_ERRORS
	WHERE OWNER = 'NAME_OF_THE_OWNER'
	AND NAME = 'NAME_OF_THE_FUNCTION_IN_UPPERCASE';

These SELECTs will return a list of all errors encountered while compiling.

Hope this helps.

Gilles Champagne
gch_at_logibec.com Received on Tue Dec 20 1994 - 22:44:06 CET