Q:

Upload file to Oracle 11g server

I need to store PDF files in my Oracle database using BFILES. I know that the file have to be present in database server file system, but all files are stored at some host in local network. My question is how to upload those files to database server using only PL/SQL. Is it possible? 

A:

PL/SQL (unless we're talking about Oracle Forms) runs on the database server.  So it can only access resources that are available on  to the database server.  
If the "host in local network" is a known file server, it should be possible for the database server to mount a directory that points to the directory on the file server where the files are stored.  If that was done, your PL/SQL code could read the files from the file server and either copy them locally to the database server or just create a BFILE that references a file on the shared drive.  
On the other hand, if you are saying that the files are stored on various client machines, you're almost certainly out of luck-- you would need some piece of code running on the client machine to send the file to the database server where it could be processed by the stored procedure.

