#94 ApexLib_integrate_into_application.sql raise with error

[Anonymous]

Apex v3.2

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - Production

.
. Enter the ID of the application: (eg. 104)
.
Enter value for add_to_application_id: 103
.
... add application process ApexLib_getGenericResult
... add application process ApexLib-Before Computation/Validation
... add application item APEXLIB_REFERENCE_ID
... add application item APEXLIB_REFERENCE_TYPE
... add application item APEXLIB_ROUTINE_TYPE
... add Page 0
... add Page0 region: Page 0 - ApexLib - Javascript/CSS
declare
*
ERROR at line 1:
ORA-20001: Package variable g_security_group_id must be set.
ORA-06512: at "APEX_030200.WWV_FLOW_API", line 48
ORA-06512: at "APEX_030200.WWV_FLOW_API", line 6476
ORA-06512: at line 20

Disconnected from Oracle Database 11g Release 11.2.0.1.0 - Production

[Anonymous]

For my own tasks I'v resolved this problem by changing first PL/SQL block of script

declare
l_wsid NUMBER; -- !!!
BEGIN
wwv_flow.g_import_in_progress := true;
wwv_flow.g_browser_language := 'en-us';
--
-- SET APPLICATION ID
wwv_flow.g_flow_id := &add_to_application_id;
wwv_flow_api.g_id_offset := 0;
SELECT w.workspace_id INTO l_wsid -- !!!
FROM apex_030200.apex_applications a, apex_030200.apex_workspaces w
WHERE a.application_id = wwv_flow.g_flow_id
AND w.workspace = a.workspace;
wwv_flow_api.set_security_group_id(l_wsid); -- !!!
END;
/
=============================================
I'm not sure that it's a clear way, but it works fine for me

[Peter Raganitsch]

Hi Anonymous,

which user did you use to connect to the database?

You need to run the integrate-script as Parsing-Schema-Owner, then it'll work flawlessly.

Peter