ORA-01741: illegal zero-length identifier

Scenario:

========

While adding multiple schemas to a single workspace, we get the following error in Apex version 4.1 which is identified as a Bug in the version

Error Faced :

===========

 "ORA-01741: illegal zero-length identifier"

Solution:

========

Run the following in the command prompt to add the schema

SYNTAX:

======

EXEC apex_instance_admin.add_schema( 'WORKSPACE_NAME', 'SCHEMA_TO_BE_ADDED' );

or 

conn as sysdba and Run the following 

BEGIN

    APEX_INSTANCE_ADMIN.ADD_SCHEMA( 'WORKSPACE_NAME', 'SCHEMA_TO_BE_ADDED');

END;

/

Example :

========

EXEC apex_instance_admin.add_schema( 'TEST', 'APEX_USER' );

PL/SQL procedure successfully completed.

Bug Reference :

=============

http://www.inside-oracle-apex.com/