Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Problems with APEX_UTIL.CREATE_USER with APEX 5.0

Hi all,
I am creating APEX-Workspaces and Users per JDBC.
Until APEX 4.2 it works well. But now wit APEX 5 there are issues:
Code which is sent to the db with 2 CallableStatements (autocommit on)
BEGIN apex_instance_admin.add_workspace(
p_workspace_id => NULL,p_workspace => 'WS_TESTC19',
p_primary_schema => 'TESTC19',
p_additional_schemas => NULL);
END;
/
declare
vSecurityGroupId NUMBER;
begin
vSecurityGroupId := APEX_UTIL.FIND_SECURITY_GROUP_ID(
p_workspace => 'WS_TESTC19'
);
wwv_flow_api.set_security_group_id(vSecurityGroupId);
APEX_UTIL.CREATE_USER(
P_USER_NAME => 'TESTC19',
P_WEB_PASSWORD => 'xxxx' ,
p_first_name => 'n/a' ,
p_last_name => 'n/a' ,
p_email_address => 'bitte eintragen',
p_developer_privs => 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
p_default_schema => 'TESTC19',
p_change_password_on_first_use => 'N',
p_description => 'TESTC'
);
end;
In SQLdeveloper this Code works well, but with APEX 5 there is an error:
ORA-20001: APEX.AUTHENTICATION.WORKSPACE_NOT_ASSIGNED
ORA-06512: at "APEX_050000.WWV_FLOW_SECURITY", line 2659
ORA-06512: at "APEX_050000.WWV_FLOW_SECURITY", line 2682
ORA-06512: at "APEX_050000.WWV_FLOW_SECURITY", line 2746
ORA-06512: at "APEX_050000.WWV_FLOW_API", line 2035
ORA-06512: at "APEX_050000.WWV_FLOW_API", line 2049
ORA-06512: at line 1
Maybe somebody has a hint.
Thank you in advance
Thomas
Answers
-
Try add this before the call to set_security_group_id
apex_instance_admin.enable_workspace(p_workspace => 'WS_TESTC19');
See
Dimitri Gielis Blog (Oracle Application Express - APEX): Apply APEX 4.1.1 Patch Set
-
-
Thank you for your answers
Regards,
Thomas