Home > Beyond, Oracle, plsql, SQL > Remove Item from Apex Collection

Remove Item from Apex Collection

declare
    l_collection_name varchar2(200) := 'MY_COLLECTION';
    l_seq_id number;
begin
    select seq_id
    into l_seq_id
    from apex_collections
    where collection_name = l_collection_name
    and c001 = :ID_SAVED_IN_THAT_COLUMN;
    
    apex_collection.delete_member( 
        p_collection_name => l_collection_name,
        p_seq => l_seq_id
    );
exception
    when no_data_found then
        null; -- The element was already deleted, dont worry about it! :)
end;
Categories: Beyond, Oracle, plsql, SQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: