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