DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, September 3, 2013

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/

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.