Re: Query Oracle error message text by error code in RDBMS

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1997/02/17
Message-ID: <3307bb24.1832895@nntp.mediasoft.net>#1/1

what do you mean "show errors" does not function? I use 7.3 and use show errors all the time.

for triggers you have to:

SQL> show errors trigger TRIGGER_NAME

On Sun, 16 Feb 1997 17:39:15 -0600, Tim Willson <tim.willson-1_at_umn.edu> wrote:

>
>------------5939268A5B591
>Content-Transfer-Encoding: 7bit
>Content-Type: text/plain; charset=us-ascii
>
>If... you are using v7.3 and writing database triggers or procedures...
>denote that showerrors does not function. To find your syntax error do:
>select * from user_errors order by line;
>
>Also note that Sql*Net V1 the p: pipe is not available for local
>connect.
>
>------------5939268A5B591
>Content-Transfer-Encoding: 7bit
>Content-Type: text/html; charset=us-ascii
>
><HTML><BODY>
>
><DT>If... you are using v7.3 and writing database triggers or procedures...
>denote that showerrors does not function. To find your syntax error do:
>select * from user_errors order by line;</DT>
>
><DT> </DT>
>
><DT>Also note that Sql*Net V1 the p: pipe is not available for local connect. </DT>
>
></BODY>
></HTML>
>------------5939268A5B591--
>

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com

http://govt.us.oracle.com

Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Mon Feb 17 1997 - 00:00:00 CST