Database Administration (MOSC)

MOSC Banner

ORA-01741: illegal zero-length identifier while create index

edited January 2011 in Database Administration (MOSC) 2 commentsAnswered
  create unique index quia.USERS_U5
on quia.USERS(CASE WHEN (
ORGANIZATION_ID IS NOT NULL
AND STUDENT_ID IS NOT NULL
AND NVL(ACCOUNT_TYPE,0)=2
AND NVL(IS_REMOVED_FROM_MASTER_LIST,'N')='N')
THEN TO_CHAR(ORGANIZATION_ID)||' '||LOWER(STUDENT_ID)
ELSE NULL
END)
tablespace DLNI_TS
online

That's the statement that is getting this error:

ERROR at line 8:
ORA-00604: error occurred at recursive SQL level 1
ORA-01741: illegal zero-length identifier

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center