Re: where's the docs for this?

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 04 Dec 2002 09:08:03 +0100
Message-ID: <3DEDB7E3.9070905@science-computing.de>

Ed Stevens wrote:
> I'm not having much luck finding the docs for what may be the most fundamental
> subject of all -- SQL return codes . . .
>
> For instance, everyone knows a +100 return code means 'not found' ....
>
> But which manual has the comprehensive documentation on all of those return
> codes? I've poked around in Tahiti and the ng archives, to no avail. I'm sure
> it must be there, but I've been unable to actually locate it!
> --
> Ed Stevens
> (Opinions expressed do not necessarily represent those of my employer.)

About two weeks ago Tom Kyte posted on asktom.oracle.com this solution (Thanks Tom!):

sql> set serveroutput on
sql> exec dbms_output.put_line (sqlerrm (100)); ORA-01403: no data found

PL/SQL procedure successfully completed.

Regards,

Holger Received on Wed Dec 04 2002 - 02:08:03 CST