Thanks for the question, Gary.
Asked: November 13, 2019 - 3:36 pm UTC
Last updated: November 26, 2019 - 5:59 pm UTC
Version: 12.1.0.2
Viewed 1000+ times
You Asked
Greetings
Environment:
Oracle 12.1.0.2 on Exadata.
I have a table with a CLOB column in which I would like to store relatively small (< 20K bytes) TXT files. The rows contain other data and updating the CLOB would be an UPDATE after other processing.
The files exist on a different server from the database.
I was initially trying to use DBMS_LOB but that requires a database directory object to be created and as far as I can tell the directory can only reference locations on the database server.
I don't have access to the server.
We do not and cannot have database links.
I can't move the files as they contain sensitive information and are on a secure server.
What fun!!
What other methods exist to get the text files into the CLOB column when the files exist on a different server from the database?
Any suggestions are most welcome!!
Thanks in advance!
-gary
and Chris said...
If you want to read the files using PL/SQL in the database you need a directory object. Which means they must be accessible from the database server.
You can do this by mounting the remote location as a file system on the database server.
If "security" means you're not able to do this, you're kinda out of options for database-side PL/SQL.
AFAIK you'll have to build an application that has access to both servers.
Rating
(2 ratings)
Is this answer out of date? If it is, please let us know via a Comment