APEX

Hi,

We're still on version 18.2. Currently what I do is create a temporary region with select apex_collections table.

I was wondering if there is a better way to do this?

I've read and was trying apex_session.attach so I can query from sql dev but I keep getting invalid workspace id even though I've already hard-coded it calling the api.

BEGIN
 apex_util.set_security_group_id (p_security_group_id => 15383631294008270);
 apex_session.attach (p_app_id       => 111232509, --  Application ID
                       p_page_id      => 9, -- Page ID
                       p_session_id   => 4945324205114 -- Session ID
                        );
END;

I'm executing this using another schema by the way so I'm not sure if there is a required role/privs before running the script above.

Appreaciate any help.