oracle insert 1400,Ora-1400 insert null error

890034 wrote:

The query returns null value which is surprising after i commited the changesWhat query? You didn't post one. Anyway:

SQL> create table city (

2 code number(3) not null,

3 name varchar(50) not null,

4 constraint city_pk primary key (code)

5 );

Table created.

SQL> create table tour (

2 code number(3) not null,

3 tour_code number(1) not null,

4 constraint tour_pk primary key (code, tour_code)

5 );

Table created.

SQL> create sequence code_seq start with 100 increment by 1 nomaxvalue nocycle nocache;

Sequence created.

SQL> insert into city values(code_seq.nextval, 'Zurich');

1 row created.

SQL> commit;

Commit complete.

SQL>

SQL>

SQL> select * from city

2 /

CODE NAME

---------- --------------------------------------------------

100 Zurich

SQL> insert into tour (code, tour_code)

2 (select code,'1' from city where name = 'Zurich');

1 row created.

SQL> select * from tour

2 /

CODE TOUR_CODE

---------- ----------

100 1

SQL>SY.