Problems with APEX_UTIL.CREATE_USER with APEX 5.0

stuetz

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

Scott Wesley

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

http://www.inside-oracle-apex.com/unable-to-login-or-run-an-application-after-applying-apex-4-1-1-patch-set/

Christian Neumueller-Oracle

Hi,

that will be fixed in 5.0.2. See Possible Bug - Apex 5 API

Regards,

Christian

stuetz

Thank you for your answers

Regards,

Thomas