ORACLE forms - OLE to WORD (HELP!!!!)

[jhoann]

Hi,

good day!

I need help ... do you have a sample code using oracle forms - OLE to MS WORD.

For example :

Table name : COMPANY
create table company(id varchar2(3), num varchar2(8), co_name varchar2(100));
insert values ('311','12345678','IBM CO LTD');

Table name : PRODUCT
create table product(id varchar2(3), num varchar2(8), products varchar2(100));
insert values ('311','12345678','Apple');
insert values ('311','12345678','Banana');
insert values ('311','12345678','Cake');

1. In my program I need to use a table where I can get my data to display... for example :

(1)
in the COMPANY table I have the following data :
ID NUM CO_NAME
311 12345678 IBM CO LTD
(2)
in the PRODUCT table I have the following data :
ID NUM PRODUCTS
311 12345678 Apple
311 12345678 Banana
311 12345678 Cake

--> In my program I want to retrieve the data that will be displayed in WORD... can it be done in Forms6i, can you show me how?

Can it be in this format (the output in WORD) :
ID : 311
NUM : 123456
Company name : IBM CO LTD
Products : Apple
Banana
Cake


I really don't know what to do... please help me... I hope you understand I'm just a starter and not familiar in using OLE.

Thanks in advance!!!!