Page 1 of 1
Is LOAD_FILE() supported by Oracle
Posted: Fri Sep 26, 2003 1:22 pm
by nirma78
Hi !!
Can anyone please let me know whether I can use the below code for a table in Oracle
I am running a php script and connecting to oracle.
Code: Select all
<?php
$load = $db->load_file("" . $file_dest . """);
?>
Thanks in advance
Posted: Fri Sep 26, 2003 3:24 pm
by JAM
You should be able to, but...
We have something similiar at work, but the only thing I can recall is that they use procedures for that, and I cant access them to see what they contain.
Check the Oracle manual for your version.
Posted: Fri Sep 26, 2003 8:12 pm
by hedge
it depends alot on what the code in the load_file method of the $db object does.
Posted: Wed Oct 01, 2003 10:01 am
by nirma78
Hi ,
Thanks for your reply,
Well can you please elaborate more on what do you mean when you say "it depends alot on what the code in the load_file method of the $db object does."
Correct me if I am wrong but shouldnt I be giving in the path to where my file is on the server ... in load_file () ??
Please help..
Thanks in advance.[/b]
Posted: Wed Oct 01, 2003 3:09 pm
by hedge
nirma78 wrote:Hi ,
Thanks for your reply,
Well can you please elaborate more on what do you mean when you say "it depends alot on what the code in the load_file method of the $db object does."
Correct me if I am wrong but shouldnt I be giving in the path to where my file is on the server ... in load_file () ??
Please help..
Thanks in advance.[/b]
Maybe I'm confused here but it looks like $db is a class, so what does the method load_file do? I am unaware of any native Oracle load_file function, there is sql loader but it is quite involved to set up.
Posted: Wed Oct 01, 2003 6:48 pm
by nirma78
Thanks,
But I am looking for any native method in Oracle to insert a file from a server location to the BLOB field into the database...
Can you help me with this please ??
Thanks in advance