Delete data from an Oracle table Error

[BritDeveloper]

We are currently trying to migrate some server jobs from v7.0 to v8.1

When trying to delete data from an Oracle table using

Code: Select all

Stage Type : OCI 9i 
Query Type : Enter Custom SQL Statement

The job aborts and generates the error message:

Code: Select all

Insert rows must be the update action to clear the table

The custom SQL is:

Code: Select all

DELETE from table where seq_no > :1

This is code works correctly V7.0 Does anyone know what may be causing this error ?

[akbar2002]

Did you put "Write Method = Delete Rows" in Input > Properties > Target ?

[ray.wurlod]

This is a server job. Don't know why this behaviour would have changed between version 7 and 8. I think you need to involve your official support provider - there may be a patch to address this issue.

[BritDeveloper]

Thanks Ray!

Ive found the following link to a patch that can resolve the problem.

http://www-01.ibm.com/support/docview.w ... wg1JR36720

But I can t find where I download it from as its not in Fix Central (That I can see!). Ive raised a service request in the hope they can point me in the right direction.

[BritDeveloper]

FYI

THis patch was just for linux... THere are rewriting it (as we speak!) for solaris... Fun!