Styjun

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;

1

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

share|improve this question

edited Mar 25 at 8:06

Nigel Ren

31.4k62036

asked Mar 25 at 7:52

MeenaMeena

257

add a comment | 

1

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

share|improve this question

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

share|improve this question

edited Mar 25 at 8:06

Nigel Ren

31.4k62036

asked Mar 25 at 7:52

MeenaMeena

257

 $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);

share|improve this question

edited Mar 25 at 8:06

Nigel Ren

31.4k62036

asked Mar 25 at 7:52

MeenaMeena

257

share|improve this question

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

asked Mar 25 at 7:52

MeenaMeena

257

asked Mar 25 at 7:52

MeenaMeena

257

1 Answer
1

active

oldest

votes

1

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

share|improve this answer

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
);



);

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

1

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

share|improve this answer

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 | 

1

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

share|improve this answer

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

share|improve this answer

answered Mar 25 at 8:05

LittlefootLittlefoot

29.6k71734

LOAD DATA infile".$myFile. "INTO TABLE test FIELDS TERMINATED BY ',' optionally enclosed ...

share|improve this answer

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