Re: Best way to store Excel spreadsheets in Oracle?

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 15 Jan 2001 02:56:11 GMT
Message-ID: <fFt86.264517$U46.8507668@news1.sttls1.wa.home.com>

If you have Oracle 8 use blob instead of a long raw. Long raw has been put into maintenance mode.
Jim

"Michael Carton" <MikeC_at_erols.com> wrote in message news:3A62467D.1C3B8822_at_erols.com...
> Van Messner wrote:
> >
> > What do you all suggest as the most effective way to do this? Store
a
> > pointer to the document? Store the document? As what - a blob? And
how is
> > the document reconstituted with all of its formatting intact after you
get
> > in out of the database? They want to have users hit the database over
the
> > web and be able to see the spreadsheets they have permissions on.
>
> I do this in my current application (Phase 1 in production has this
feature, Phase 2
> is in development.) I store the whole file in a LONG RAW column. Works out
quite well.
>
> --
> MikeC
>
> Please reply to the group.
Received on Sun Jan 14 2001 - 20:56:11 CST