Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sqldev 19.1 worksheet missing line numbers for erroneues DML's

KarstenH-dkMay 7 2019 — edited May 7 2019

Hi

When running a dml script the worksheet in sqldeveloper does not tell me the number of the erroneues line

create table mytab(

val number(8,0),

val1 number(10,0));

insert into mytab(

        val,

        val1)

        values (

        1111111111,

        1111111111);

Error report -

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

NO linenumber  !!!!!!!!!!!!!

SQLplus does tell me the linenumber

FEJL i linie 5:

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

This error or rather missing function, seems to be reinstated with version 19.1

regards Karsten

Comments

Oyvind Isene

The first statement for declaring the package is not really relevant, or am I missing something? Anyway, I did this in latest version of SQL Developer against an 11.2.0.4 database without getting any errors:

create or replace type user1_type 
AS OBJECT ( DEMO VARCHAR2(3)) ; 
/
create table nobeer 
( col1 user1_type ) ; 
SELECT * FROM NOBEER ;
1 person found this helpful
1 - 1

Post Details

Added on May 7 2019
#sql-developer
3 comments
136 views