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

[ragonz]

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='control/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]

Please post the exact error message that it is throwing?

[ragonz]

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