Problems inserting data using insert service adapter


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?


Hi Sweety,

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