Home » SQL & PL/SQL » SQL & PL/SQL » How to store files from clob column to local path
How to store files from clob column to local path [message #190069] Tue, 29 August 2006 03:49 Go to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

I have a table with clob column

CREATE TABLE TAB_CLOB
(
FNAME VARCHAR2(30 BYTE),
ICLOB CLOB,
uploaded_time DATE
)

Above table contains text files in CLOB column.

Now i have to write a procedure to get the files from clob column based on the fname and
store it in server 'D:\..'

This should be done in pl/sql only....

oracle version : Version 9.2.0.7.0

Naveen







Re: How to store files from clob column to local path [message #190176 is a reply to message #190069] Tue, 29 August 2006 10:02 Go to previous message
rigatonip
Messages: 50
Registered: December 2005
Member
You can parse the clob and then use utl_file to dump it to a file. See this askTom link for an example.
Previous Topic: How do I find special characters using a regular expresion?
Next Topic: function returning array
Goto Forum:
  


Current Time: Wed Dec 07 22:31:16 CST 2016

Total time taken to generate the page: 0.24267 seconds