3 Replies Latest reply on Feb 24, 2016 4:20 PM by thatJeffSmith-Oracle

    SQL*Loader-350: Syntax error at Line 1. Expecting keyword LOAD, found "nullLOAD".

    3062371

      I'm automating a dataloading process using below command line.

      sdcli cart cloud -cart C:\xxx\cart_1.sdcart.xml -cfg C:\xxx\deploy_cloud_tool.xml

       

      Not sure why in SQL Developer (4.1.3.20, MAIN-20.78) UI I can deploy cart to cloud successfully but after executing above command line I get below result.

      SQL*Loader error.

      SQL*Loader: Release 11.2.0.3.0 - Production on Tue Feb 23 07:45:06 2016

      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

      SQL*Loader-350: Syntax error at line 1.

      Expecting keyword LOAD, found "nullLOAD".

      OPTIONS (ERRORS=91) nullLOAD DATA CHARACTERSET "AL32UTF8" LENGTH CHARnu

                                             ^

      SQL*Loader: Release 11.2.0.3.0 - Production on Tue Feb 23 07:45:06 2016

       

      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

       

      SQL*Loader-350: Syntax error at line 1.

      Expecting keyword LOAD, found "nullLOAD".

      OPTIONS (ERRORS=91)nullLOAD DATA CHARACTERSET "AL32UTF8" LENGTH CHARnu

                                            ^

      It turns out the cart_1.zip file generated by sdcli command has malformed .ctl file content. Can someone please suggest what might be wrong with my case? Thanks a lot!

      OPTIONS (ERRORS=91)nullLOAD DATA CHARACTERSET "AL32UTF8" LENGTH CHARnullINFILE 'HELP_DATA_TABLE.ldr' "str '{EOL}'"nullAPPENDnullCONTINUEIF NEXT(1:1) = '#'nullINTO TABLE "HELP"nullFIELDS TERMINATED BY'|'nullOPTIONALLY ENCLOSED BY '"' AND '"'nullTRAILING NULLCOLS ( null"TOPIC" CHAR (50),null"SEQ" ,null"INFO" CHAR (80))null