Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Direct loaderpath problems

Direct loaderpath problems

From: Steve Bardsley <steve.bardsley_at_mottmac.com>
Date: 23 Oct 1998 14:07:41 GMT
Message-ID: <01bdfe8f$58b3d1c0$7a44688a@tosh740.mottmac.com> 





I am having problems using SQLLOAD to load data files that have CHAR
datatype strings, but are blank. 


The columns are "not null" so when loading they are rejected. With
conventionalpath mode it is possible to specify a qualifying sql function
e.g. "NVL(:fieldname,' ')" to get around the problem, but direct loaderpath
does not support this.



Any ideas



Steve
Received on Fri Oct 23 1998 - 09:07:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US