Re: Useless error msg

From: Scott Urman <surman_at_wwsun10.us.oracle.com>
Date: 30 Nov 1994 19:19:07 GMT
Message-ID: <3bij7b$aqf_at_dcsun4.us.oracle.com>


In article <D01EzA.1DD_at_cup.hp.com>, jbridges_at_cup.hp.com (Jim Bridges) writes:
|> 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?
|>

Type 'show errors'. Check the SQL*Plus manual for more details. The function exists, but has a status of invalid (query user_objects). The errors are stored in user_errors, and 'show errors' queries this data dictionary view for you and presents the errors in a readable format. Received on Wed Nov 30 1994 - 20:19:07 CET

Original text of this message