DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Help in ORA-01741: illegal zero-length identifier

  1. #1
    Join Date
    Jul 2007
    Posts
    21

    Help in ORA-01741: illegal zero-length identifier

    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...,

  2. #2
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Use single quotes i.e. ''.

    Don't use double quotes "".

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    post the table definition

  4. #4
    Join Date
    Jul 2007
    Posts
    21
    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

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    if you are loading via sqlloader then you arent using insert statements like you posted.

    So which is it?

  6. #6
    Join Date
    Jul 2007
    Posts
    21
    While loading from sqlldr, this data is alone rejected...,
    So, i just wanted to insert it manually to check...,

    Thanks..,

  7. #7
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Have you checked log file? It will give you exact error.

    Post error from logfile.

  8. #8
    Join Date
    Aug 2007
    Posts
    2
    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.

  9. #9
    Join Date
    Aug 2007
    Posts
    2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width