Posted by : Saravanan
Introduction
This Post demonstrates about error 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 and it is fixed in version 4.2
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/
