[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    RE:  LOBs
From:       "Justin Cave \(DDBC\)" <jcave () ddbcinc ! com>
Date:       2004-05-28 17:54:55
Message-ID: F001.005E5959.20040528104924 () fatcity ! com
[Download RAW message or body]

LOB's are only stored internally in the database.  BFILEs are, in
essence, pointers to files on the server.  Oracle can modify LOB's, but
it cannot modify BFILEs.

Using UTL_FILE to generate a file from a CLOB is the most
general-purpose (and probably the easiest) option.  If you are dealing
with XML files, XML DB has some interesting functionality here, exposing
XML files stored in the database via FTP, for example. 


Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
Tom Berthoff
Sent: Friday, May 28, 2004 10:44 AM
To: Multiple recipients of list ODTUG-SQLPLUS-L

Hi,

I'm trying to puzzle through the Oracle 9i documentation regarding LOBs.

What I want to do is write information to a CLOB and then output the
CLOB to a text file on the server. Do I have to go through UTL_FILE to
accomplish this? I read (for instance) that "BFILEs may not be written
through Oracle". Doesn't a LOB refer to a server file? Is there any way
to get that file once it's created?

Tom

Tom Berthoff
Senior Applications Developer
Home Health Corporation of America
620 Freedom Business Center
Suite 105
King of Prussia, PA 19406
610-205-2458 x316

--
ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the Westin
Kierland Resort, Scottsdale, Arizona.  Visit http://www.odtug.com for
details.--
Author: Tom Berthoff
  INET: bertht@hhcainc.com

Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L (or the
name of mailing list you want to be removed from).  You may also send
the HELP command for other information (like subscribing).


-- 
ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the Westin Kierland
Resort, Scottsdale, Arizona.  Visit http://www.odtug.com for details.-- 
Author: Justin Cave \(DDBC\)
  INET: jcave@ddbcinc.com

Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
[prev in list] [next in list] [prev in thread] [next in thread]