SQL*LOADER: How to read in TIME fields?

From: Andreas Seebeck <A.Seebeck_at_t-online.de>
Date: 1998/03/18
Message-ID: <6eo1md$fj8$1@news00.btx.dtag.de>#1/1

Hi,

does anybody know how I can read time fields with sqlloader? In the ascii file they are written like 21:30:00. In the control file I tried it with CHAR, DATE and DATE "hh-mm-ss" and DATE "hh:mm:ss", but nothing works.
SQLLoader gives this message:

Record 1: Rejected - Error on table KUNDEN_LEISTUNG. OCA-30021: error preparing/executing SQL statement [POL-2416] invalid date/time format

The database is Personal Oracle Lite, and the field type is TIME.

Any suggestions?

Thanks in advance,
Andreas Seebeck Received on Wed Mar 18 1998 - 00:00:00 CST