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!

DELETE FROM apex_collections

GUS CRIGHTON2 days ago

Apex 24.2

I am working with apex collections in a pl/sql package.

I dentify errors and then mark the line

APEX_COLLECTION.UPDATE_MEMBER(
p_collection_name => 'NEW_SCAN',
p_seq => c1.seq_id,
p_c050 => 'DELETE');

All is working fine until I try to

DELETE FROM APEX_COLLECTIONS
WHERE collection_name = 'NEW_SCAN'
AND c050 = 'DELETE';

Then I get an error message

[Error] Compilation (847: 17): PL/SQL: ORA-01031: Nicht ausreichende Berechtigungen

Any help appreciated

Regards

Gus

This post has been answered by Jan-Marcel van Dijken on Jan 6 2026

Jump to Answer

Added 2 days ago

2 comments

60 views