| Urgent help in SQL* Loader please [message #131921] |
Wed, 10 August 2005 01:43  |
misha603
Messages: 20
Registered: July 2005
Location: India
|
Junior Member |
|
|
Hi,
I have 2 Database LVFD and HIS
I have a table called RHISBLO in HIS DB. I have created a synonym fOR that in LVFD using DB link.
I am able to select and do all DML operations on RHISBLO from LVFD.
When I try to upload data in RHISBLO of HIS DB using SQL Loader from LVFD DB I get the following error
----------------------------------------------------------------
SQL*Loader: Release 8.1.6.3.0 - Production on Wed Aug 10 08:39:17 2005
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL*Loader-925: Error while ulmtsyn: OCIStmtExecute(tabhp)
ORA-01405: fetched column value is NULL
----------------------------------------------------------------
My command prompt command is
----------------------------------------------------------------
sqlldr userid=his1/his1 control=step2/rhisblo.ctl log=rhisblo.log
----------------------------------------------------------------
My control file is
----------------------------------------------------------------
LOAD DATA
INFILE '/tmp/rhisblo.dat'
APPEND INTO TABLE RHISBLO
FIELDS TERMINATED BY '~'
TRAILING NULLCOLS
(
NUVEH INTEGER EXTERNAL
, COCAUBLO CHAR
, DDORDBLO DATE "DD-MON-YYYY HH24:MI:SS" NULLIF (DDORDB
LO=BLANKS)
, DFORDBLO DATE "DD-MON-YYYY HH24:MI:SS" NULLIF (DFORDB
LO=BLANKS)
, COTEXBLO CHAR NULLIF (COTEXBLO=BLANKS)
, COTEXDBL CHAR NULLIF (COTEXDBL=BLANKS)
, COSIT CHAR NULLIF (COSIT=BLANKS)
, DCHISBLO DATE "DD-MON-YYYY HH24:MI:SS" NULLIF (DCHISB
LO=BLANKS)
, CODOOBLO CHAR
)
----------------------------------------------------------------
Please help me
Thanks in advance
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
