Reconstructing a document from database

From: Steve Johns <johns_at_oxygen.stx.com>
Date: 1997/12/30
Message-ID: <34A9A2DF.167E@oxygen.stx.com>#1/1

Hi.

I'm trying to come up with a good architecture to store a formatted text document in ORACLE, and then reconstruct/recover it.

Sample of doc:

Characteristic: Favorites
  Favorite Food: Ice cream
  Favorite Color: Red
  Favorite Qotation: <Long text of quotation> End_Char

Database sample structure:

Table Favorites

Food VARCHAR2(100)
Color VARCHAR2(100)
Quotation LONG

At issue is how to most efficiently and easily reconstruct the document, with its labels, from the table data, which contains the values, but not the labels which are required for those values in the document.

Choices: PL/SQL, Custom PRO*C code, Oraperl, Java, others???

The goal is to replace a complex set of custom C code (with external dictionaries, special file formats, miles of spaghetti, etc.) with a SIMPLE, extensible system based upon "industry standard" techniques. Received on Tue Dec 30 1997 - 00:00:00 CST