OMrun Help Online Manual for OMrun Version 4

Body


OMrun Data Object Icon

Abstract

At the the end of any query in source A or B it is possible to add a body part. 
The body part is ment to be an execution module to run any type of data transformation or data export / import funtionality where the query part is a read only function.

To distinguish the body part from the query the key word /*BODY*/ is needed to separate the content.


Body Conventions

The query can consist of two parts and are separated by the tag /*BODY*/

  • Sql query part
  • Pl/Sql / Stored procedure part

For body content any sql script (plsql, stored procedures etc.) is allowed. If a script expects return values they need to be redirected into data base variables or output files.


Execution Order

The order how the different sql parts are executed is fix. A body part is allways optional.

Test Object Data execution order:

  1. Query Source A
  2. Body Source A
  3. Commit Source A
  4. Query Source B
  5. Body Source B
  6. Commit Source B

Parameter

Parameters in a /*BODY*/ part are used the same way as in a query.

The use of the following parameters / variables is allowed:

  • Parameters (@param1 - @param4) from the parameter list
  • Environment variables like @VAR_Environment
  • System environment variables like %SystemEnvVar%

Attention!

Ensure you do have elevated access rights for the db user defined within the OMrun environment to execute body parts in your test object.

Be especially careful with the body scripts. They are very powerfull and in case of using it the wrong way, they have the potential to destroy your data source you are addressing!