CODEWITHSUNDEEP
oracle-databasesql-loader
Brooklyn Devroy
Brooklyn Devroy

Reputation: 11

Issue with date timestamp to Oracle SQL Loader. Error is missing comma

Here's what I have in my control card. 

updt_tmstmp "YYYY-MON-DD HH24.MI.SS",

But when I load the error code is

ORA-00917: missing comma

Not sure how to fix.

Thanks!

Upvotes: 1

Views: 149

Answers (1)

Littlefoot
Littlefoot

Reputation: 143013

It would probably help if you posted a little bit more of the control file; anyway, it seems that TO_DATE is missing, e.g.

updt_tmstmp "to_date(:updt_tmstmp, 'YYYY-MON-DD HH24.MI.SS')",

Upvotes: 1

Related Questions