Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql loader error Expecting "," or ")", found "VENDOR_SITE_INTERFACE_ID".*

MuthuJan 31 2013 — edited Jan 31 2013

Hello all,

While running the below sql loader file I got the error (attached below).

INTO TABLE AP_SUPPLIER_SITES_INT
WHEN (01) = 'T'
fields terminated by "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
REC_SKIP FILLER POSITION(1)
VENDOR_SITE_INTERFACE_ID "ap_supplier_sites_int_s.NEXTVAL",
VENDOR_INTERFACE_ID "ap_suppliers_int_s.CURRVAL",
LAST_UPDATE_DATE "SYSDATE",
LAST_UPDATED_BY,
VENDOR_ID,
VENDOR_SITE_CODE,
CREATION_DATE "SYSDATE",
CREATED_BY,
PURCHASING_SITE_FLAG,
PAY_SITE_FLAG,
ADDRESS_LINE1,
ADDRESS_LINE2,
ADDRESS_LINE3
)

The below error i am getting....

*SQL*Loader-350: Syntax error at line 11.*
*Expecting "," or ")", found "VENDOR_SITE_INTERFACE_ID".*
*VENDOR_SITE_INTERFACE_ID "ap_supplier_sites_int_s.NEXTVAL",*
*^*

Thanks and Regards,
Muthu