Re: Forms OLE Automation with Word

You are looking for integration Oracle data within Microsoft Word. You can use Ole2, but it's rather slow.
We have developed SQLWord that might be interesting for you: 

        SQLWord:

        Advanced Reportwriter integrating Oracle and Microsoft Word.
        You can create your own standardletters, contracts and any
        other reports using the data of an Oracle database within a
        Microsoft Word document. By placing the fieldnames (keywords)
        of the queries in the text of the document, SQLWord retrieves
        the necessary data from the Oracle database and integrates it
        in the generated output document. Nested structures can be used
        unlimited (master-detail-detail etc).

Please have a look at our wbsite at www.sequel.nl.

Sincerely,

Sequel Solutions
 

Dolf-Jan Mulder wrote:

Hello,

I use the following procedures to exchange data form Forms to Word. The
problem that occurs that only the first occurence of a variable is replaced.
I want a 'replace all'. Can somebody point out how to code this?
procedure EditGoTo (txt in varchar2) is
  arglist ole2.list_type;
begin
  -- txt is a variable in Forms
  arglist := ole2.create_arglist;
  ole2.add_arg (arglist, '<'||txt||'>');
  ole2.invoke (obj_hnd, 'editfind', arglist);
  ole2.destroy_arglist (arglist);
end;

procedure InsertText (txt in varchar2) is
  arglist ole2.list_type;
begin
  -- txt is the value for the variable
  arglist := ole2.create_arglist;
  ole2.add_arg (arglist, txt);
  ole2.invoke (obj_hnd, 'insert', arglist);
  ole2.destroy_arglist (arglist);
end;

Thanks, Dolf-Jan