Am using
$command = "sqlldr userid=abc/abc_def@defghijk CONTROL= $controlFileName DATA=\"$csvFilePath\" LOG=$logFile1 BAD=$logFile2";
exec($command,$output,$returnValue);
And got the output :
SQL*Loader: Release 11.2.0.1.0 - Production on Wed Feb 19 15:53:58 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 196.
Instead of this output, is it possible to get the below part of result from log file into PHP :
Table table_name:
195 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Partition SYS_P42102: 195 Rows loaded.
Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576
Total logical records skipped: 2
Total logical records read: 196
Total logical records rejected: 1
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 2
Total stream buffers loaded by SQL*Loader load thread: 0
i.e, i want to return value from sqlldr command that how many rows was read and how many rejected and how many inserted?
thanks.