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