sql loader and ora-01008 (cross posted to tools)

From: Patricia J. Paulson <patpaulson_at_qwest.net>
Date: Tue, 10 Jul 2001 19:57:54 -0700
Message-ID: <0wN27.2181$H06.602167@news.uswest.net>

Hi,

I am trying to run sql loader to load a flat file and keep getting error ora-01008 (not all variables bound). Any suggestions? The control file is straightforward, copied right over another that works, just changed table and column names and positions. Also having problems with a date column, says the datatypes are incompatible (it just needs to convert 20010707 and the format mask is DATE "RRRRMMDD) I don't have it here, I'm at home now. I'm just back to work after 5 months (maternity).

Any help would be greatly appreciated!!

Thanks,
Pat Received on Tue Jul 10 2001 - 21:57:54 CDT