Re: a quandry please help....

In Pro*----, look at field SQLERRD(5) for the Parse Error Offset.

In OCI, look bytes 8-9 in your CDA.

rstanford9811_at_my-dejanews.com wrote:

> When Oracle's sqlplus encounters an error, it puts an asterisk under the
> place where it thinks the error is (turns out this is frequently the table,
> so maybe this isn't as helpful as I thought).
>
> update jtest1 set cola = 'aaaaabbbbbcccccdddddeeeee'
> *
> ERROR at line 1:
> ORA-01401: inserted value too large for column
>
> In this case cola is a varchar2(20), so the string is too long.
>
> I would like to capture and print the message from Oracle with
> the accompanying sql statement, just like the above, and put
> it into a message for the user. Otherwise, I can capture the
> error number, but then have to test all the columns for what
> caused the problem. TEDIOUS!
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Aug 20 1998 - 08:48:01 CDT