Location: Database

Discussion: ORA-01741 errorReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 2 posts
bhkrmv
bhkrmv
ORA-01741 error
Mar 5 2009, 5:34 AM EST | Post edited: Mar 5 2009, 5:34 AM EST
Hi Experts,

I request you to explain the ORA-01741 error "illegal zero-length identifier".

Thanks in advance
Bharath Kumar V Do you find this valuable?    
Keyword tags: None
luciofer
luciofer
1. RE: ORA-01741 error
Mar 5 2009, 2:42 PM EST | Post edited: Mar 5 2009, 2:43 PM EST
From "Oracle Database 9i Release 2 Database Error Messages":

ORA-01741 illegal zero-length identifier
Cause: An attempt was made to use two double quotes ("") as an identifier. An
identifier must be at least one character long.
Action: Insert at least one character between the double quotes in the identifier.
If a blank identifier is required, specify a blank space between the double quotes
(" ").

It's pretty self-explanatory :)

If you are getting the error, can you say how?

Cheers Do you find this valuable?