ORA-01400 cannot insert "not null" although variable has value

[Ruudbern]

Hi Marco,

I have a problem with a not nullable field which is filled by the oracledataset Sequencefield property. (on new record) This always works perfect normaly.

In Oracle monitor i can see that the sequence value is fetched and is used in the variable during the insert statement. (no triggers concerned)

One of our customers gets an "ORA-01400 can not insert null" error. I read in an other post there is an problem with oracle 11 in relation with returning rowid. Is this the same problem?

We use version 4.0.6.2. is there a workaround for this version?

Kind regards

Ruud

 

[Marco Kalter]

Only version 4.1 works around this Oracle Server bug, so you will need to upgrade to that version.

 

[Ruudbern]

Zoiks! Then we will have to make the jump to 4.1

Do you know if newer version of DOA is still compatible with older versions of reportbuilder/woll2woll?

thanks for the info.

Ruud

 

[Marco Kalter]

Version 4.1 is fully compatible with 4.0.

 

[Ruudbern]

Hi Marco,

We upgraded to 4.1. The Jump to 4.1.1 went very smooth.
The problem is solved. Thanx.