Previous  Next          Contents  Index  Navigation  Glossary  Library

Writing a SQL*Plus Script for Microsoft Word

Now that you have identified whether you want to associate the standard letters with student enrollment or applicant assignment statuses, you are ready to identify which data you want to extract from the database.

Oracle HRMS supplies SQL*Plus script templates. It also supplies two sample Microsoft Word documents containing merge codes for the SQL*Plus scripts. You can copy the SQL*Plus scripts from the server side sql directory of the HR or product tree. (Consult your installation guide for details).

Oracle Training Administration does not provide template scripts, but we provide an example of a Confirmation letter SQL mail merge file, see OTA SQL*Plus Script

You can copy the word documents from the client-side directory [APPL_TOP]\PER76\LETGEN.

You can run the scripts on the server side and make them accessible to other users across the network, or you must copy them to a directory which is accessible from the PC, such as a network drive. You must also make the Microsoft Word documents accessible to other users across the network, or you must copy them to each PC.

Templates Provided

The template scripts and Microsoft Word documents Oracle HRMS provides are:

Scripts and Documents Purpose Used By
PERWPOUS.sql Example US Offer letter SQL mail merge file HR
PERWPOUK.sql Example UK Offer letter SQL mail merge file HR
PERWPIUS.sql Example US Interview letter SQL mail merge file HR
PERWPIUK.sql Example UK Interview letter SQL mail merge file HR
PERWPOUS.doc Example US Offer MS Word document HR
PERWPOUK.doc Example UK Offer MS Word document HR
PERWPIUS.doc Example US Interview MS Word document HR
PERWPIUK.doc Example UK Interview MS Word document HR

One of the template SQL*Plus scripts is provided as an example, see Template SQL*Plus Script PERWPOUK

Oracle Training Administration does not provide template scripts, but we provide an example of a Confirmation letter SQL mail merge file, see OTA SQL*Plus Script

To write a SQL*Plus script for Microsoft Word:

Performing the Next Step:

You now need write your skeleton letter. See: Writing a Skeleton Letter

To generate your Microsoft Word letter, see Generating a Microsoft Word Letter


         Previous  Next          Contents  Index  Navigation  Glossary  Library