tag:blogger.com,1999:blog-1003209687173038896.post8940540359264817048..comments2024-03-02T05:54:53.634+01:00Comments on APEX by G: View data from APEX collections in PL/SQL IDEMarko Goričkihttp://www.blogger.com/profile/00170426101592251779noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-1003209687173038896.post-49703949317505647652019-06-06T09:01:31.189+02:002019-06-06T09:01:31.189+02:00Look at this post https://apexbyg.blogspot.com/201...Look at this post https://apexbyg.blogspot.com/2018/06/apex-181-debugging-of-apex-sessions-was.htmlMarko Goričkihttps://www.blogger.com/profile/00170426101592251779noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-76838222745428894862019-06-06T09:00:47.585+02:002019-06-06T09:00:47.585+02:00Seems ok, but I think there's no output. What&...Seems ok, but I think there's no output. What's the output of your PL/SQL block?<br />If you're on APEX 18.* or above you can use apex_session.create_session.Marko Goričkihttps://www.blogger.com/profile/00170426101592251779noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-85370190487635102822019-06-06T07:32:56.177+02:002019-06-06T07:32:56.177+02:00what am I doing wrong? :
declare
v_workspace_i...what am I doing wrong? :<br /><br />declare<br /> v_workspace_id apex_workspaces.workspace_id%type;<br />BEGIN<br /><br />select workspace_id<br /> into v_workspace_id<br /> from apex_workspaces<br /> where workspace = 'GCOS_UPGRADE';<br /><br /> -- Set Workspace ID<br /> apex_util.set_security_group_id(v_workspace_id);<br /><br /> -- Set Application ID<br /> apex_application.g_flow_id := &APP_ID; <br /> <br /> -- Set Session ID<br /> apex_application.g_instance := &APP_SESSION; <br /><br /> FOR i IN (SELECT *<br /> FROM APEX_collections<br /> WHERE collection_name = 'P506_COMPARE_BULK_TAGS')<br /> LOOP<br /> HTP.p ('');<br /> END LOOP;<br />END;priveshhttps://www.blogger.com/profile/10782945204307276080noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-47550213486092611672013-02-18T23:39:31.022+01:002013-02-18T23:39:31.022+01:00Np, anytime ;)Np, anytime ;)Marko Goričkihttps://www.blogger.com/profile/00170426101592251779noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-77074815271097982822013-02-07T21:04:10.727+01:002013-02-07T21:04:10.727+01:00Fantastic. Thank you for the pointer.Fantastic. Thank you for the pointer.Anonymoushttps://www.blogger.com/profile/02155325396660952784noreply@blogger.com