i'm trying to load data from uploaded file in php by using sql loader

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ragonz
    New Member
    • Jul 2008
    • 24

    i'm trying to load data from uploaded file in php by using sql loader

    im having trouble in executing sql loader command in php. i already posted this issue in php forum, but didn't give me clear answer yet.

    probably posting in this forum would be better.

    here's what i've tried :
    $cmand="sqlldr userid=system/pass control='contro l/data.dat'";
    system($cmand);

    in php, we can see the result line. it works but only reached the header of the sqlldr command n it suddnly stopped. what should i do then?

    thx
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    Please post the exact error message that it is throwing?

    Comment

    • ragonz
      New Member
      • Jul 2008
      • 24

      #3
      Originally posted by amitpatel66
      Please post the exact error message that it is throwing?
      If executed in cmd prompt, then it should be like this one

      SQL*loader : release 10.2.0.1.0 - Production on Tue Jul 29 07:33:49 2008
      Copyright <c> 1982,2005, Oracle. All rights reserved.

      Commint point reached - logical record count 64
      Commint point reached - logical record count 128
      Commint point reached - logical record count 192
      Commint point reached - logical record count 256
      Commint point reached - logical record count 320
      Commint point reached - logical record count 353
      Commint point reached - logical record count 354


      But in php, it's just like this

      SQL*Loader: Release 10.2.0.1.0 - Production on Tue Jul 29 07:38:04 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved.

      there're no message error at all and the process just stopped.
      i don't know why..

      Thx

      Comment

      Working...