473,221 Members | 1,895 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

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 3271
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

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

Similar topics

0
by: Matthias Stern | last post by:
Hi! I'm using the MySQL "Load data" command to load big .csv files into a MySQL database. Sometimes there are special characters within these .csv files which cause some kind of "displacement"...
7
by: Adriano | last post by:
Hello, can anyone help me to make progress bar in the status bar that will show the status of SQL data loading into dataset, tnx in advance, Adriano
2
by: johnny | last post by:
hi all, I wonder why this little script doesn't work, maybe it's the provider not allowing the use of load data infile ( I know some don't let users to run some tasks ), could you please tell me...
1
by: Sumanth | last post by:
We are using cli bulk loader to load data into db2. In some cases the rows get rejected and this is flagged as a warning allowing the program to continue. Is there any way to trap this warning,...
5
by: Justin | last post by:
Hi, im facing a problem here. First of all here is my program requirement. I got a .csv file with thousands of records inside, i need to import them into my mysql database. So i tried using load...
1
by: drec | last post by:
I have a table in which its primary key is auto-incremented. Yet, when I try to load data using load data infile, this column will not auto-increment. I am leaving that column blank in my file to...
5
by: pbd22 | last post by:
Hi. I am trying to poll a long-running process via a hidden IFrame. I am noticing that the online errata gives advice for handling a server response: window.parent.handleServerResponse(); ...
0
by: shaqa | last post by:
I try to do this but i cannot. i creat two layers with actionscript seperated as slideshow need to be,,and i try to put in one rectangle all of my images but cannot put in work,it doesnt load when i...
1
anfetienne
by: anfetienne | last post by:
i have this code below that i made....it loads vars from txt file splits it then puts it into an array....once in an array it the brings the pics in from the array to create thumbnails and a larger...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.