| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> SQLLDR Issue - again
Ok, the file is not a comma delimited file. It is fixed with and fixed column. Here is a cut from my control file:
DATE_BILLING POSITION(118:125) DATE(8) "YYYYMMDD" NULLIF (DATE_BILLING = " "),
I changed it to this:
DATE_BILLING POSITION(118:125) DATE(8) "YYYYMMDD" "decode(DATE_BILL ING, '00000000' null, ' ', null)",
I got this error message:
SQL*Loader-417: SQL string (on column DATE_BILLING) not allowed in direct path.
Any ideas?
Thanks,
Arthur
amerar_at_ci.chi.il.us
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Sep 21 1999 - 10:17:19 CDT
 |
 |