Re: error messages in sql*plus - oracle Technet?

From: Sathish Balas <sathishudercor_at_home.com>
Date: Thu, 18 Oct 2001 22:46:52 GMT
Message-ID: <wZIz7.60435$le.9072432@news1.rdc1.va.home.com>

From Ask tom website :

---

STANLEY -- Thanks for the question regarding "oerr ", version 8.0.5

---

---

You Asked

hi tom,
is there a utility like oerr of Unix
in NT?

thanks for the reply.

---

---

and we said...

No there is not.

You can do this in sqlplus:

tkyte_at_TKYTE816> exec dbms_output.put_line( sqlerrm( -1422 ) ); ORA-01422: exact fetch returns more than requested number of rows

• Sathish

"Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote in message news:rykz7.9515$Og4.1283075_at_news0.telusplanet.net...
> On Windows you need to install the Documentation to look up the error
> messages.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> "Ron Reidy" <rereidy_at_indra.com> wrote in message
> news:3BCDC887.801217B8_at_indra.com...
> > MIKLTD wrote:
> > >
> > > Can someone please show me if oracle has something like Technet that
you
> can
> > > use for error messages in oracle
> > On UNIX, use 'oerr'; on Windows you are SOL.
> > --
> > Ron Reidy
> > Oracle DBA
> > Reidy Consulting, L.L.C.
>
>
Received on Thu Oct 18 2001 - 17:46:52 CDT