Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> a quandry please help....
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
![]() |
![]() |