2 Replies Latest reply on Aug 14, 2017 7:48 PM by Gary Graham-Oracle

    Any way to get SQL Devloper to show the column for an ORA-01438 error?

    Jim 13131

      Example in SQL Developer 17.2 / Oracle 12.1.0.2

       

      create table test1438  (a number(5), b number(2));

      insert into test1438 values (123,456);

       

      Error starting at line : 2 in command -

      insert into test1438 values (123,456)

      Error report -

      ORA-01438: value larger than specified precision allowed for this column

       

      So what column is "This column"? SQL Plus will show me the column as below but SQL Developer will not:

       

      SQL> insert into test1438 values (123,456);

      insert into test1438 values (123,456)

                                       *

      ERROR at line 1:

      ORA-01438: value larger than specified precision allowed for this column

       

      The real example I hit was a far more complex insert on a table with 50+ columns. I had to open SQL Developer to find the issue and even with wrapping of the long query to multiple lines I was able to line up the * with the bad column quickly.

       

      But I hate SQL Plus - It would have been far faster to get this information in SQL Developer and I'm hoping there is a way to do this.

       

      Jim