Re: Getting data out from LOBs

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 10 Jun 2004 13:23:43 +1000
Message-ID: <40c7d42b$0$31679$afc38c87@news.optusnet.com.au>

"Kalle" <kminerva_at_jippii.fi> wrote in message news:NlQxc.18713$g4.359036_at_news2.nokia.com...
> Hello,
>
> I have a problem: I have been asked whether it is possible to "download"
> the documents to word -format from the database where docs are stored as
> a LOB...
>
> Any ideas,
>
> Thank you in advance
> kalle

It's of course do-able. It depends a bit on how you want to go about doing it, though. I do precisely this sort of thing using, ahem, an MS Access front end, with a object field on a form bound to the relevant column in the Oracle table. Double-clicking the form launches Word and opens the document. That's just one possibility, though. There's all sorts of others. If you're lucky, Norman will chime in here with a bit of PL/SQL code using DBMS_LOB to achieve the same thing... (Norman's my PL/SQL guru!).

Regards
HJR Received on Wed Jun 09 2004 - 22:23:43 CDT