11) LNCPRTDOC : Oracle

In this example, the database has the following characteristics :

• Type DB : Oracle

• Database server address : 192.168.1.7

• Port number of the database server : 1521

• Database user : hr

• Database user password : hr

• Database name : XE

• SQL query : select * from employees

The command LNCPRTDOC is used to generate the following Word document:

C:\temp\TEST2_oracle.doc

The template used for mail merging is :
C:\temp\SP_CUST_ORACLE.DOC

String template = "C:\\temp\\SP_CUST_ORACLE.DOC";
String destination = "C:\\temp\\TEST2_oracle.DOC";

     DataSource myDataSource = new DataSource();
     myDataSource.setType("oracle");
     myDataSource.setSrvAddr("192.168.1.7");
     myDataSource.setPort("1521");
     myDataSource.setUser("hr");
     myDataSource.setPassword("hr");
     myDataSource.setDBName("XE");
     myDataSource.setQuery("select * from employees");

     LNCPRTDOC myLNCPRTDOC = new LNCPRTDOC();
     myLNCPRTDOC.setDoc(template);
     myLNCPRTDOC.setSavFmt("*NORMAL");
     myLNCPRTDOC.setShowDoc("true");
     myLNCPRTDOC.setMrgType("*FILE");
     myLNCPRTDOC.setOutSave("true");
     myLNCPRTDOC.setSavDoc(destination);
     myLNCPRTDOC.setMrgSel("*LTR");
     myLNCPRTDOC.setExecMrg("true");
     myLNCPRTDOC.setEndOpt("*NONE");
     myLNCPRTDOC.setHeaderSrc("*FILE");
     myLNCPRTDOC.setSourceData(myDataSource);
     myLNCPRTDOC.setSourceData(myDataSource);
     myLNCPRTDOC.setLNCSrvAddr("192.168.1.9");

myLNCPRTDOC.execute();