Oracle Application Express (MOSC)

MOSC Banner

APEX 19.1 Shuttle Item (Shuttle Controls)

edited Nov 4, 2019 1:09PM in Oracle Application Express (MOSC) 2 commentsAnswered ✓

I am working with a shuttle item that on the left queries a database table for all groups  available to a user. The right side returns a query on the same table showing the groups which are currently assigned to the user.

I can shuttle the items back and forth using the built-in shuttleControl buttons, then after everything is done use a “submit changes” button.

In this button I have code similar to:


declare

    tab apex_t_varchar2;   

begin    

    delete from TECH_GROUPS

     where USER_ID  = :P30_SELECTED_USER_ID;

commit;

        tab := apex_string.split (:P30_GROUPS, ':');  

        for i in 1..tab.count loop

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center