Home » Developer & Programmer » Forms » Oracle 12c Forms Developer Integration with MicroSoft Word (Oracle Forms [64 Bit] Version 12.2.1.2.0 (Production).)
Oracle 12c Forms Developer Integration with MicroSoft Word [message #659855] Wed, 01 February 2017 03:27 Go to next message
Qaiser.Bashir
Messages: 32
Registered: July 2007
Location: Rawalpindi
Member

1. I am using Oracle Forms [64 Bit] Version 12.2.1.2.0 (Production).
2. I had a form which contains one text field which capture text and number data and that data is stored in database.
3. I want to add a button which give me the functionality that my text field data should go to Microsoft word document with out using java beans.
4. I want to open/retrieve my stored data in Microsoft Word Document with complete formatting(Bold, Italic, Underline, Paragraph) from FORM and
vice versa, without using java beans.
5. I want to edit my data in Microsoft Word Document and want to save in DB with complete formatting(Bold, Italic, Underline, Paragraph) , on
closing that word document.

What are the steps to develop such type of forms.
Re: Oracle 12c Forms Developer Integration with MicroSoft Word [message #659857 is a reply to message #659855] Wed, 01 February 2017 03:33 Go to previous messageGo to next message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
First thing - you can't store formatting data in a varchar column. That's binary metadata held in the doc file.
You'll probably need to actually store the doc file itself in the DB as either a BLOB or a BFILE.
Re: Oracle 12c Forms Developer Integration with MicroSoft Word [message #659858 is a reply to message #659857] Wed, 01 February 2017 03:58 Go to previous messageGo to next message
Qaiser.Bashir
Messages: 32
Registered: July 2007
Location: Rawalpindi
Member

I had done this thrugh using the java beans and stored the data in varchar2 formate. the stored data looks like
<html>
<head>

</head>
<body>
<table width="20%" border="2" height="1">
<tr>
<td>
<p>
122
</p>
</td>
</tr>
<tr>
<td>
<p>
2
</p>
</td>
<td>
<p>
3
</p>
</td>
</tr>
</table>
</body>
</html>

you can see the data in attached /forum/fa/13439/0/
Re: Oracle 12c Forms Developer Integration with MicroSoft Word [message #659859 is a reply to message #659858] Wed, 01 February 2017 04:46 Go to previous messageGo to next message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
And the point of that image is what?
Re: Oracle 12c Forms Developer Integration with MicroSoft Word [message #659882 is a reply to message #659859] Wed, 01 February 2017 21:18 Go to previous messageGo to next message
Qaiser.Bashir
Messages: 32
Registered: July 2007
Location: Rawalpindi
Member

The Image shows the stored data. i put the text in a field using Forms and after saving the data the data is stored in database in the form of varchar2 (as showed in the image).
Re: Oracle 12c Forms Developer Integration with MicroSoft Word [message #659885 is a reply to message #659882] Thu, 02 February 2017 03:41 Go to previous messageGo to next message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
And what do you want to do with that data?
Re: Oracle 12c Forms Developer Integration with MicroSoft Word [message #659886 is a reply to message #659885] Thu, 02 February 2017 04:13 Go to previous messageGo to next message
Qaiser.Bashir
Messages: 32
Registered: July 2007
Location: Rawalpindi
Member

these data is captured by using the java beans.
I don't want to use java beans for this purpose.
i want it to be direct capturing data by using Microsoft tools as there is no need of java beans to incorporate the Microsoft tools in oracle forms 12c.
I want to add a button which give me the functionality that my text field data should go to Microsoft word document with out using java beans.
Re: Oracle 12c Forms Developer Integration with MicroSoft Word [message #659887 is a reply to message #659886] Thu, 02 February 2017 04:32 Go to previous messageGo to next message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well I personally don't know how to call word from forms, though I'm sure there are examples at the other end of a google search.

What I do know is that standard forms text items will not show data with the formatting you apply in word. So if that's your requirement the requirement is going to have to change.
Re: Oracle 12c Forms Developer Integration with MicroSoft Word [message #659901 is a reply to message #659887] Thu, 02 February 2017 13:20 Go to previous message
Littlefoot
Messages: 21548
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you rely that much on Microsoft, why don't you switch to it completely? It offers development tools, its own database (MS SQL Server) so maybe you could do what you want to do much easier than in Oracle world.
Previous Topic: OLE2 Usage-Documentation Information
Next Topic: Form help in check box
Goto Forum:
  


Current Time: Sat Apr 04 04:54:42 CDT 2020