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.
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.
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!