Hello ,
I am having below control file , trying to load into dept and emp table but sqlldr is loading into dept table only not in emp.

can u please advise if any thing is wrong in the control file
===========================
Load
infile *
Replace
into table dept
when deptno !=''
(deptno position(1:2) char,
dname position(4:6) char,
loc position(8:10) char
)
into table emp
when empno !=''
(empno position(12:13) char,
ename position(15:19) char
)

BEGINDATA

10 FIN NAG 40 Ashok
20 PAY BOM 50 Amol
30 HUM DEL 60 Anil
=====================

Thanks & Regds


Amol