Re: oracle errors

Hi,

Maybe you're looking for a command that lists errors in stored procedures etc?

"show errors" would help in such a case, though I like "select * from user_errors"
better (or dba_errors if you'd like to see a lot of them :-) )

Jef Jakobs

Sybrand Bakker wrote:

> There is no such command, at least not within the database.
> If you are running on an Unix platform you could use the oerr utility. The
> syntax for this is oerr <facility> <error>
> so oerr ora 1017 etc.
> Similar third party tools for NT exist, I don't have any URLs
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <marima_at_my-deja.com> wrote in message news:8i8rqk$gjr$1_at_nnrp1.deja.com...
> > whats the syntax for the command to list oracle errors
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Thu Jun 15 2000 - 00:00:00 CDT