Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Error position in sql statement

Re: Error position in sql statement

From: Keith Jamieson <pdkj02_at_email.mot.com>
Date: Wed, 02 Dec 1998 09:37:01 +0000
Message-ID: <36650A3B.9E8D244B@email.mot.com>


I use a variable in pro*c called position and increment by 10 every time an sql statement is called. This then gets written out to a log file along with the error code and error text.

James J. Schmidt wrote:

> haven't checked on pro*c lately, missing last time I was subjected to it,
> but this is trivial in OCI.
>
> Sven Heins wrote in message <3647029F.6AE5F84A_at_solution42.de>...
> >Hi there,
> >
> >can anyone tell me an easy way to get the error position of the last sql
> >statement.
> >
> >Thanks for your help,
> >
> >Sven
> >
Received on Wed Dec 02 1998 - 03:37:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US