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

Home -> Community -> Usenet -> c.d.o.server -> a quandry please help....

a quandry please help....

From: <rstanford9811_at_my-dejanews.com>
Date: Wed, 19 Aug 1998 21:13:49 GMT
Message-ID: <6rff6d$fqe$1@nnrp1.dejanews.com>


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 Wed Aug 19 1998 - 16:13:49 CDT

Original text of this message

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