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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: How do I find special characters using a regular expresion?
Next Topic: function returning array
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 13:22:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.