Re: Storing MS Word doc in database
Date: Fri, 16 Oct 1998 06:28:14 GMT
Message-ID: <706p1t$b1o$1_at_nnrp1.dejanews.com>
Hi Guys,
Sorry to barge in, but I have got this desperate problem that I thot you guys
might be able to help.
Do you know exactly what happened?
Description of the problem:
1. Oracle Forms opens a document in Microsoft Word using Automation
(formerly
known as OLE Automation).
2. The Document_Open event method in the .dot file attached to the document
starts executing. (Its purpose is to populate data from text files into the
document.)
3. As long as the Document_Open event method is executing, Windows System,
Users, and GDI resources keep decreasing at a rate of about 10% every 3-5
seconds.
4. If the Document_Open event method has not finished executing after about
30
seconds, the computer will lock up. If we press Ctrl-Alt-Del, Windows will
display the message "The system is dangerously low in resources..."
When Microsoft Access opened the same document in Microsoft Word using Automation, all the resources I mentioned above did not drop. The problem occurs _only_ when the document is opened from Oracle Forms.
Why? Could it be a defective automation engine (.DLL) that is not used by Office 97?
In article <3615F6BD.DE22EC7A_at_sequel.nl>,
akolkman_at_sequel.nl wrote:
>
> --------------0AA8E88523C6CA170AB61CB0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Dear Peter,
>
> We have developed a nice solution for the integration between
> Oracle*Forms and Microsoft Word. You can download our product SQLWord at
> www.sequel.nl
>
> SQLWord is an advanced Reportwriter integrating Oracle and Microsoft
> Word. You can create your own standardletters, contracts and any other reports
> using the data of a Oracle database within a Microstoft Word document.
> You can run SQLWord from Oracle*Forms using the same Oracle connection.
>
> Sincerely,
>
> Arthur Kolkman / Sequel Solutions
>
> Peter Staunton wrote:
>
> > I'm running Forms 5 with Oracle 8 and have a requirement to store a binary
> > in the database and transfer it to the disk on the client. In this case,
> > it's a word document that I then want to invoke using OLE.
> >
> > Has anyone done this? Do I need to write C code and then perform user exits
> > from Forms?
> >
> > Your help is much appreciated. Please reply to pjs_at_iol.ie
> >
> > Thanks,
> > Peter
>
> --------------0AA8E88523C6CA170AB61CB0
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <HTML>
> Dear Peter,
>
> <P>We have developed a nice solution for the integration between
> <BR>Oracle*Forms and Microsoft Word. You can download our product
> SQLWord at <U><FONT COLOR="#3366FF">www.sequel.nl</FONT></U>
>
> <P><B>SQLWord </B>is an advanced Reportwriter integrating Oracle and Microsoft
> <BR>Word. You can create your own standardletters, contracts and any other
> reports
> <BR>using the data of a Oracle database within a Microstoft Word document.
> <BR>You can run SQLWord from Oracle*Forms using the same Oracle connection.
>
> <P>Sincerely,
>
> <P>Arthur Kolkman / Sequel Solutions
> <BR>
> <BR>
>
> <P>Peter Staunton wrote:
> <BLOCKQUOTE TYPE=CITE>I'm running Forms 5 with Oracle 8 and have a requirement
> to store a binary
> <BR>in the database and transfer it to the disk on the client. In this
> case,
> <BR>it's a word document that I then want to invoke using OLE.
>
> <P>Has anyone done this? Do I need to write C code and then perform user
> exits
> <BR>from Forms?
>
> <P>Your help is much appreciated. Please reply to pjs_at_iol.ie
>
> <P>Thanks,
> <BR>Peter</BLOCKQUOTE>
> </HTML>
>
> --------------0AA8E88523C6CA170AB61CB0--
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 16 1998 - 08:28:14 CEST