OK, Kari, there is no sequence created that you can use for inserting records into the Scott.Emp table.  So, I tried to manually assign one and got the same error you did.  I tracked it down and corrected the problem and we will be posting an update before the end of the week with some changes to the activation wizard, so this will be included as well.  Thanks for your patience.

Great!

Just in case if the update gets delayed, would it be possible to get the "insert"-fix so that I could work on this project during the week-end. Now I'm sort of stuck....

Cheers,

Kari

Well, not really... there were several places within the OracleDataSourceItem that changed in order for it to pass the new unit tests, but what I can do is post a new install here by the end of today.

Ben,

thank you very much.

Kari

Hi,
just as information, after downloading the latest version of SF (dated 10-10-2006) the attached sample worked and allowed to create a new record into the EMP table.

Cheers,
Kari

ps. Incase somebody tries the example - add the DEPTNO field to the form. Otherwise you get a referential integrity error from Oracle.

Good to know about that foreign key that exists on the EMPS table.  Thanks for the heads up and I'm glad you're working