Re: dynamic error value in sql loader
From: Steffen Conrad <steffen.conrad_at_gmx.de>
Date: Wed, 19 May 2004 14:22:26 +0200
Message-ID: <2h11mqF7s6muU1_at_uni-berlin.de>
Date: Wed, 19 May 2004 14:22:26 +0200
Message-ID: <2h11mqF7s6muU1_at_uni-berlin.de>
Munish Gupta wrote:
> 1.) at the command where sql loader is run. But as i am running this
> command thru a batch file.. i am unable to pass it a dynamic value..
why not count the amount of rows in the batch file and set appropriate errorcount in the sqlldr call?
for linux/unix this would simple:
NUM_OF_ROWS = 'wc -l input_file'
sqlldr ... errors=$NUM_OPF_ROWS ...
Steffen Received on Wed May 19 2004 - 14:22:26 CEST