Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: where's the docs for this?
spamdump_at_nospam.noway.nohow (Ed Stevens) wrote in message news:<3df0a58f.2060182_at_ausnews.austin.ibm.com>...
> On 5 Dec 2002 14:56:19 GMT, "Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> wrote:
>
> >,Ed Stevens <spamdump_at_nospam.noway.nohow> wrote:
> >: On 4 Dec 2002 11:25:06 -0800, afilonov_at_yahoo.com (Alex Filonov) wrote:
>
> >:>spamdump_at_nospam.noway.nohow (Ed Stevens) wrote in message news:<3deb862b.
> 12044679_at_ausnews.austin.ibm.com>...
> >:>> 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!
> >:>
> >:>Use Error Messages manual. For 8i part number would be A76999-01. It's on
> > Tahiti.
> >
> >: I must be looking right at it at not seeing what I'm looking for. To be a
> bit
> >: more specific, here's my problem.
>
> >: We are converting an application (written in Cobol from) from os/2 and db2/2
> to
> >: NT and Oracle. After issuing a SQL statement, the pgms check the SQLCODE
> field
> >: of the SQLCA record. This is just a numeric return code, not a full-blown
> error
> >: message. It is these codes that I need to find and I'm not finding any
> >: reference to this field or its values in the Error Messages manual.
> >
> >
> >: --
> >: Ed Stevens
> >: (Opinions expressed do not necessarily represent those of my employer.)
> >
> >What value are you getting? Getting anything in sqlca.sqlerrm.sqlerrmc?
> >
> >Helen
>
> Wrong problem. It's not that we're getting codes we don't understand. We're
> converting programs from DB2/2 to Oracle, and we need to make sure that existing
> tests are checking for the correct codes. For example, in DB2/2 a SQLCODE of
> 'xyz' indicates a certain error condition, so we need to determine what value
> Oracle returns to indicate the same condition. We know for a fact that they
> aren't all the same.
I don't think I get the problem, but does $ORACLE_HOME/sqlplus/mesg help?
jg
-- @home is bogus. It's ok to talk to yourself. It's ok to answer yourself. It's when you go "huh?" to the answer that you have a problem.Received on Fri Dec 06 2002 - 19:10:48 CST