Problems inserting data using insert service adapter

,
1

Hi,

I’ve a created a table in Oracle and a sequence so that the ID is generated automatically each time I insert a new record. Then in developper, I’ve created an insert service adapter but when I run it, I get errors saying that It is impossible to insert NULL values to the ID. I can’t understand why my sequence is not taken into consideration. When through SQL+ I insert some data using the INSERT INTO command, everything works out fine. Could someone please help me find out what is wrong?

Thanks,
Sweety.

2

Hi Sweety,

In the insert adapter service under Insert tab give the value for the Expression as ..nextvalue instead of ?