This content has been marked as final. Show 3 replies
your question is not really clear:
I'm able to generate file from CLOB using function,unfortunately it resides inside db and developer is not able to access it.I guess you are talking about using UTL_FILE package. In this case the file DOES NOT reside inside db but on a file system which is accessible by Oracle.
I still don't understand what is your goal?
Create a file and send to some other applications?
What are you doing with non CLOB data?
Please give us the whole picture. You could consider writing an application which is reading the CLOB data and writing it in a local directory but I did not understand if this is the solution dropped for security,
Check this link: [url:http://www.dba-oracle.com/t_export_unload_blob_clob.htm]http://www.dba-oracle.com/t_export_unload_blob_clob.htm
sorry Alberto. I was in hurry to put everything down at once.
Insert CLOB into database.
Search keyword from CLOB.
Extract content of CLOB field and display to user.
First two however are went successful. But for getting clob into varchar2 is not working. varchar2 is not able to handle such large data.
Link that you have provided is the option dropped for security reason.
Question, in short get data from clob. Having this 2 options (if any possible :)):
1) get data in varchar2 from clob
2)get data from clob and put it into file(using utl_file) and available that file to other remote server.
And 1 more thing
If you have other option to get clob data as string/any variable then please let me know.