We had to import an sql script delivered by a US based company in an Oracle 11g database. Everything went fine except for to_timestamp function that had letter code month values. All to_timestamps with MAR for March failed. As not being a dba I searched around bit and found out that the database we’re importing in should be set to American language and American Territory. Quite logic actually.
But it didn’t help.
Continue reading “Note to self, set NLS parameters for Oracle DB Clients”