0

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.

arul.k
  • 69
  • 1
  • 3
  • 7

0 Answers0