Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQLloader wont load certain column when called from VB?
Hi there,
As you can see I have a problem with SQlloader not loading a certain column. In visual basic I call sqlloader with some params pointing to a script from a shell. This works fine for most, but there is one script where it just refuses to load a certain column somewhere in the middle of the file.
The script is ok though, I think, when I cut and paste the commandline from VB to a batch file, and run it, all columns load fine. But when I tried to do this from vb it just doesnt load this one particular column, which is wierd since it basicly just spawns an invisble prompt and runs the same command line as in the batchfile. You'd expect either to completely fail, or succes, not just to ignore a column in the middle of the file. The logfile doesnt report any errors though.
The column itself is nothing special, just a varchar2 of 3 chars. I checked the datafile, no data errors there either and the positions are correct.
I am at a total loss here! Received on Tue Oct 02 2001 - 05:36:28 CDT
![]() |
![]() |