Hello,

I would like to delete all records, where no order number already exists in the table tauftr_ge. Here an example of the statement:

delete from tplan_kw_pos x where x.id =  (select a.id from tplan_kw_pos a left join tauftr_ge b on a.auftragsjahr = b.jahr and a.auftragsnr = b.nr where b.nr is null and a.id = x.id)

I get an error, The cursor identified in the UPDATE or DELETE statement is not positioned on a row.

no current record for fetch operation.

It looks simple, delete some records, but what can be wrong?

Thank you.