APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive Report with delete function?

van Baal HROct 30 2017 — edited Nov 2 2017

Hello you experts!

My customer wants to be able to delete single positions from the trolley and I think that with the Interactive Report this is not possible. At least I do not know how. The possibility to be able to delete single order positions is an absolute necessity, the customer stated. I have created another page with an Interactive Grid to delete the records, but appearently the records are empty (?!)

When I click the "Entfernen" (DELETE) button, a delete is attempted, but fails due the fact, that :WA_NR and the other page items are NULL (???) An INSERT prooves this:

insert into errortab values

( :APP_USER

, NVL (:WA_KONZERN_NR, '1234')||' '||NVL ( :WA_FIRMA_NR, '1234')||' '||NVL ( :WA_BETRIEB_NR, '1234')||' '||:WA_TEIL_NR||' '||:WA_POS_NR||' '||:WA_POS1_NR

, SYSDATE

);

COMMIT;

When I check the content of the error table, I see, that my message is there too: