Is LOAD_FILE() supported by Oracle

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
nirma78
Forum Commoner
Posts: 42
Joined: Wed Sep 17, 2003 2:02 pm

Is LOAD_FILE() supported by Oracle

Post 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
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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.
hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post by hedge »

it depends alot on what the code in the load_file method of the $db object does.
nirma78
Forum Commoner
Posts: 42
Joined: Wed Sep 17, 2003 2:02 pm

Post 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]
hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post 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.
nirma78
Forum Commoner
Posts: 42
Joined: Wed Sep 17, 2003 2:02 pm

Post 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
Post Reply