Load data infile in to oracle table using phpHow can I prevent SQL injection in PHP?Get list of all tables in Oracle?Deleting an element from an array in PHPConvert HTML + CSS to PDF with PHP?startsWith() and endsWith() functions in PHPHow do I get PHP errors to display?How do you parse and process HTML/XML in PHP?Reference — What does this symbol mean in PHP?How does PHP 'foreach' actually work?Why shouldn't I use mysql_* functions in PHP?
Is there a term for the belief that "if it's legal, it's moral"?
How does DC work with natural 20?
Has there been any indication at all that further negotiation between the UK and EU is possible?
Concurrent normals conjecture
If the Dragon's Breath spell is cast on a familiar, does it use the wizard's DC or familiar's DC?
How to maintain a closed environment for one person for a long period of time
What's currently blocking the construction of the wall between Mexico and the US?
Why are < or > required to use /dev/tcp
How can lift be less than thrust that is less than weight?
Does the monk's Step of the Wind feature activate the benefit of the Mobile feat?
How long would it take to cross the Channel in 1890's?
Understanding the reasoning of the woman who agreed with Shlomo to "cut the baby in half"
Why do all the teams that I have worked with always finish a sprint without completion of all the stories?
Methodology: Writing unit tests for another developer
Android Material and appcompat Manifest merger failed in react-native or ExpoKit
What is the meaning of "понаехать"?
Do I have to explain the mechanical superiority of the player-character within the fiction of the game?
Is "Busen" just the area between the breasts?
What does it mean to not be able to take the derivative of a function multiple times?
How did Gollum enter Moria?
RandomInteger with equal number of 1 and -1
Is there any proof that high saturation and contrast makes a picture more appealing in social media?
Can White Castle?
Identifying unknown map projection for image
Load data infile in to oracle table using php
How can I prevent SQL injection in PHP?Get list of all tables in Oracle?Deleting an element from an array in PHPConvert HTML + CSS to PDF with PHP?startsWith() and endsWith() functions in PHPHow do I get PHP errors to display?How do you parse and process HTML/XML in PHP?Reference — What does this symbol mean in PHP?How does PHP 'foreach' actually work?Why shouldn't I use mysql_* functions in PHP?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I want load data from text file to oracle database using php , what function to be used here to prevent this warning?
$myFile = "local.txt";
$fh = fopen($myFile, 'r') or die("Could not open: " . mysql_error());
echo " file opened<br>";
$sql ="LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed by".'" ' ."(acc_nbr)";
$result = odbc_execute($connect_cc,$sql) or die("Couldn't execute query! ".odbc_errormsg());
if(!$result)
echo " file has not been uploaded to database";
else
echo " File has been uploaded successfully to database";
fclose($fh);
Warning: odbc_execute() expects parameter 2 to be array, string
given in C:xampphtdocsFTPMonthly_Segmentation_process.php on line
59
Couldn't execute query!
php oracle
edited Mar 25 at 8:06
Nigel Ren
31.4k62036
asked Mar 25 at 7:52
MeenaMeena
257
add a comment |
I want load data from text file to oracle database using php , what function to be used here to prevent this warning?
$myFile = "local.txt";
$fh = fopen($myFile, 'r') or die("Could not open: " . mysql_error());
echo " file opened<br>";
$sql ="LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed by".'" ' ."(acc_nbr)";
$result = odbc_execute($connect_cc,$sql) or die("Couldn't execute query! ".odbc_errormsg());
if(!$result)
echo " file has not been uploaded to database";
else
echo " File has been uploaded successfully to database";
fclose($fh);
Warning: odbc_execute() expects parameter 2 to be array, string
given in C:xampphtdocsFTPMonthly_Segmentation_process.php on line
59
Couldn't execute query!
php oracle
edited Mar 25 at 8:06
Nigel Ren
31.4k62036
asked Mar 25 at 7:52
MeenaMeena
257
add a comment |
I want load data from text file to oracle database using php , what function to be used here to prevent this warning?
$myFile = "local.txt";
$fh = fopen($myFile, 'r') or die("Could not open: " . mysql_error());
echo " file opened<br>";
$sql ="LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed by".'" ' ."(acc_nbr)";
$result = odbc_execute($connect_cc,$sql) or die("Couldn't execute query! ".odbc_errormsg());
if(!$result)
echo " file has not been uploaded to database";
else
echo " File has been uploaded successfully to database";
fclose($fh);
Warning: odbc_execute() expects parameter 2 to be array, string
given in C:xampphtdocsFTPMonthly_Segmentation_process.php on line
59
Couldn't execute query!
php oracle
edited Mar 25 at 8:06
Nigel Ren
31.4k62036
asked Mar 25 at 7:52
MeenaMeena
257
I want load data from text file to oracle database using php , what function to be used here to prevent this warning?
$myFile = "local.txt";
$fh = fopen($myFile, 'r') or die("Could not open: " . mysql_error());
echo " file opened<br>";
$sql ="LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed by".'" ' ."(acc_nbr)";
$result = odbc_execute($connect_cc,$sql) or die("Couldn't execute query! ".odbc_errormsg());
if(!$result)
echo " file has not been uploaded to database";
else
echo " File has been uploaded successfully to database";
fclose($fh);
Warning: odbc_execute() expects parameter 2 to be array, string
given in C:xampphtdocsFTPMonthly_Segmentation_process.php on line
59
Couldn't execute query!
php oracle
php oracle
edited Mar 25 at 8:06
Nigel Ren
31.4k62036
asked Mar 25 at 7:52
MeenaMeena
257
edited Mar 25 at 8:06
Nigel Ren
31.4k62036
asked Mar 25 at 7:52
MeenaMeena
257
edited Mar 25 at 8:06
Nigel Ren
31.4k62036
edited Mar 25 at 8:06
Nigel Ren
31.4k62036
edited Mar 25 at 8:06
Nigel Ren
31.4k62036
31.4k62036
asked Mar 25 at 7:52
MeenaMeena
257
asked Mar 25 at 7:52
MeenaMeena
257
asked Mar 25 at 7:52
MeenaMeena
257
257
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
This:
LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed ...
looks like SQL*Loader's control file.
I don't think you can use it elsewhere.
It means that
- you have to call
SQLLDR.EXE - which will call the control file (such as
MY_LOAD.CTL) - which contains all those options you wrote above
answered Mar 25 at 8:05
LittlefootLittlefoot
29.6k71734
Thank you , do you have any PHP reference related? how to call it?
– Meena
Mar 25 at 9:36
No, sorry; I don't speak PHP.
– Littlefoot
Mar 25 at 12:22
Thank you , I have done it using php with shell_exec function.
– Meena
Mar 26 at 6:01
You're welcome; I'm glad you fixed it.
– Littlefoot
Mar 26 at 6:05
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55333310%2fload-data-infile-in-to-oracle-table-using-php%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This:
LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed ...
looks like SQL*Loader's control file.
I don't think you can use it elsewhere.
It means that
- you have to call
SQLLDR.EXE - which will call the control file (such as
MY_LOAD.CTL) - which contains all those options you wrote above
answered Mar 25 at 8:05
LittlefootLittlefoot
29.6k71734
Thank you , do you have any PHP reference related? how to call it?
– Meena
Mar 25 at 9:36
No, sorry; I don't speak PHP.
– Littlefoot
Mar 25 at 12:22
Thank you , I have done it using php with shell_exec function.
– Meena
Mar 26 at 6:01
You're welcome; I'm glad you fixed it.
– Littlefoot
Mar 26 at 6:05
add a comment |
This:
LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed ...
looks like SQL*Loader's control file.
I don't think you can use it elsewhere.
It means that
- you have to call
SQLLDR.EXE - which will call the control file (such as
MY_LOAD.CTL) - which contains all those options you wrote above
answered Mar 25 at 8:05
LittlefootLittlefoot
29.6k71734
Thank you , do you have any PHP reference related? how to call it?
– Meena
Mar 25 at 9:36
No, sorry; I don't speak PHP.
– Littlefoot
Mar 25 at 12:22
Thank you , I have done it using php with shell_exec function.
– Meena
Mar 26 at 6:01
You're welcome; I'm glad you fixed it.
– Littlefoot
Mar 26 at 6:05
add a comment |
This:
LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed ...
looks like SQL*Loader's control file.
I don't think you can use it elsewhere.
It means that
- you have to call
SQLLDR.EXE - which will call the control file (such as
MY_LOAD.CTL) - which contains all those options you wrote above
answered Mar 25 at 8:05
LittlefootLittlefoot
29.6k71734
This:
LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed ...
looks like SQL*Loader's control file.
I don't think you can use it elsewhere.
It means that
- you have to call
SQLLDR.EXE - which will call the control file (such as
MY_LOAD.CTL) - which contains all those options you wrote above
answered Mar 25 at 8:05
LittlefootLittlefoot
29.6k71734
answered Mar 25 at 8:05
LittlefootLittlefoot
29.6k71734
answered Mar 25 at 8:05
LittlefootLittlefoot
29.6k71734
answered Mar 25 at 8:05
LittlefootLittlefoot
29.6k71734
29.6k71734
Thank you , do you have any PHP reference related? how to call it?
– Meena
Mar 25 at 9:36
No, sorry; I don't speak PHP.
– Littlefoot
Mar 25 at 12:22
Thank you , I have done it using php with shell_exec function.
– Meena
Mar 26 at 6:01
You're welcome; I'm glad you fixed it.
– Littlefoot
Mar 26 at 6:05
add a comment |
Thank you , do you have any PHP reference related? how to call it?
– Meena
Mar 25 at 9:36
No, sorry; I don't speak PHP.
– Littlefoot
Mar 25 at 12:22
Thank you , I have done it using php with shell_exec function.
– Meena
Mar 26 at 6:01
You're welcome; I'm glad you fixed it.
– Littlefoot
Mar 26 at 6:05
Thank you , do you have any PHP reference related? how to call it?
– Meena
Mar 25 at 9:36
Thank you , do you have any PHP reference related? how to call it?
– Meena
Mar 25 at 9:36
No, sorry; I don't speak PHP.
– Littlefoot
Mar 25 at 12:22
No, sorry; I don't speak PHP.
– Littlefoot
Mar 25 at 12:22
Thank you , I have done it using php with shell_exec function.
– Meena
Mar 26 at 6:01
Thank you , I have done it using php with shell_exec function.
– Meena
Mar 26 at 6:01
You're welcome; I'm glad you fixed it.
– Littlefoot
Mar 26 at 6:05
You're welcome; I'm glad you fixed it.
– Littlefoot
Mar 26 at 6:05
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55333310%2fload-data-infile-in-to-oracle-table-using-php%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
