Help in ORA-01741: illegal zero-length identifier

[Shining Star]

Hi All,

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
xxxxxx_yyyyyy",0,"window.location="http://svc.xxxyyyy.com/",10,"","",0);

ERROR:
ORA-01741: illegal zero-length identifier

Thanks...,

[bhattnirav]

Use single quotes i.e. ''.

Don't use double quotes "".

[davey23uk]

post the table definition

[Shining Star]

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
----------------------------------------- -------- -----------------
SES_ID NUMBER
TRANS_ID NUMBER
TRANS_ANALYSIS NUMBER
TRAN_NAME VARCHAR2(100)
RANK_1_F NUMBER
RANK_1_T NUMBER
T_TIME_O NUMBER
T_SINGLE_URL_TX_U VARCHAR2(500)
T_REPORT_OR NUMBER
T_TRANSACTION_DE VARCHAR2(500)
T_EXIST_IN_SCRIPT NUMBER
T_TEXT_CHECK_DATA VARCHAR2(100)
T_TEXT_CHECK_FLAG NUMBER
T_URL_USER VARCHAR2(100)
T_URL_PASS VARCHAR2(100)
T_URL_PASS_ETY NUMBER

[davey23uk]

if you are loading via sqlloader then you arent using insert statements like you posted.

So which is it?

[Shining Star]

While loading from sqlldr, this data is alone rejected...,
So, i just wanted to insert it manually to check...,

Thanks..,

[bhattnirav]

Have you checked log file? It will give you exact error.

Post error from logfile.

[roxboroman]

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.

[roxboroman]

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:

,"window.location="http://svc.xxxyyyy.com/",

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.