CODEWITHSUNDEEP
oracle-database
Pranav Kevadiya
Pranav Kevadiya

Reputation: 539

Oracle - Access a remote file to read

I have this very specific requirement.

My database server is running on some linux server X, where I have written some stored procedure which will read the file from a DIRECTORY and create an XML table based on the content of that xml file.

Now, The file in picture can come from any machine i.e. it is uploaded by user in Browser and then we need to process it with the stored procedure.

Is there a way I can access the file of my local machine from the database server without mount/ftp? I mean, is there any utility in Oracle which can access file system of the client to read the file content?

Upvotes: 0

Views: 1082

Answers (1)

atokpas
atokpas

Reputation: 3351

is there any utility in Oracle which can access file system of the client to read the file content?

No, there is not. PLSQL program cannot reach your client PC. You have to upload it to the server then can use UTL_FILE to interpret it.

Upvotes: 1

Related Questions