Help in ORA-01741: illegal zero-length identifier
i am getting the following error,
Could any one help..,
insert into xxxx_yyyy values (398,290,12,"xxxxxxx",8010,12000,100000,"http://xxxyyyy.com/Click?q=47-ADvxIIZm1jH1FHBfbkjol3EkKomR",44,"T
ORA-01741: illegal zero-length identifier
Use single quotes i.e. ''.
Don't use double quotes "".
post the table definition
Actually i am loading from the flat file to the table using sqlldr.
the flat file contains double quotes only.
my table desc is below..,
Name Null? Type
----------------------------------------- -------- -----------------
if you are loading via sqlloader then you arent using insert statements like you posted.
So which is it?
While loading from sqlldr, this data is alone rejected...,
So, i just wanted to insert it manually to check...,
Have you checked log file? It will give you exact error.
Post error from logfile.
To get this insert working, you need to surround Character fields in your VALUES clause with single quotes, not double quotes. ORACLE thinks that character fields surrounded by double quotes are identifiers (column names), and of course, NULL identifiers are not allowed (see ..."","",0... at the end of your VALUES clause)
This does not explain why your SQLLDR is not working, but I also assume that is not the error that SQLLDR was producing.
Also, if the VALUES clause that you posted is a valid representation of the data in your SQLLDR flat file, then the data is not correctly formatted. The section:
has three double quotes, but no intervening comma separator. If you specify that columns of data are comma-delimited, SQLLDR will produce an error message. You need to correct the data.
Click Here to Expand Forum to Full Width