RE: Storing html pages in DB

I've worked in apps that stored large HTML source in an Oracle database, and it used a datatype of CLOB. We didn't encounter any real problems with storing the data in that type of field, but just check to see what type of connection is going to retrieve the HTML from the database field. In that particular job, we had to use the OCI jdbc drivers with our Java code to allow the retrieval of the CLOB data to occur. The application was unable to do this with the thin JDBC driver. I have to look back as to why, there was some reason but can't remember it. :)

Tom Tyson

• "Thater, William" <ThaterW_at_telergy.net> wrote:
  > I thought that's what CLOBs were for, or am I way off base here?
  >
  > --
  > Bill Thater Certified ORACLE DBA
  > Telergy, Inc. thaterw_at_telergy.net
  > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  > "We are different, in essence from other men.
  > If you want to will something run 100m.
  > If you want to experience something run a marathon"
  > Emil Zatopek
  > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  > "If the facts don't fit the theory, change the facts."
  > -- Albert Einstein
  >
  >
  >
  > -----Original Message-----
  > Sent: Tuesday, October 31, 2000 1:15 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > Hi All,
  > One of our app requires storing HTML pages in the oracle (816) database. We
  > are using
  > varchar2(4000) for the field. Now we are hitting the 4000 limit. Can I use
  > raw for this? All
  > ideas and comments are welcome.
  >
  > Thanks
  > Praveen
  > --
  > +===========================================================================
  > +
  > | Praveen K. Gautam
  > |
  > | Tellabs, Inc.
  > |
  > +===========================================================================
  > +
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Praveen Gautam
  > INET: gautam_at_pipeline.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-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).
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Thater, William
  > INET: ThaterW_at_telergy.net
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-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).