468,103 Members | 1,328 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,103 developers. It's quick & easy.

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

24
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
Jul 27 '08 #1
2 2894
amitpatel66
2,367 Expert 2GB
Please post the exact error message that it is throwing?
Jul 28 '08 #2
ragonz
24
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
Jul 29 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Matthias Stern | last post: by
7 posts views Thread by Adriano | last post: by
2 posts views Thread by johnny | last post: by
1 post views Thread by Sumanth | last post: by
5 posts views Thread by Justin | last post: by
1 post views Thread by drec | last post: by
5 posts views Thread by pbd22 | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.