The following plugin provides functionality available through
Pipeline-compatible steps. Read more about how to integrate steps into your
Pipeline in the
section of the
For a list of other such plugins, see the
Pipeline Steps Reference
SQLPlus Script Runner
step([$class: 'SQLPlusRunnerBuilder']): SQLPlus Script Runner
Inform instance information (example:
ORCL). You can use global variable like
This is the name of SQL script, expected at
This is a custom SQL script.
| SELECT sysdate from dual;
Using custom ORACLE_HOME will override global ORACLE_HOME. Leave this field blank to use global ORACLE_HOME. ORACLE_HOME refers to either a directory where the Oracle software is installed or an environment variable pointing to the directory where the Oracle software is installed.
Using custom SQL*Plus will help find SQL*Plus executable file, this helps if you are working with Jenkins slave machines. Example:
Learn more about distributed builds
Using custom TNS_ADMIN refers to a directory where the Oracle SQL*Net configuration files (like sqlnet.ora and tnsnames.ora) are located. Example:
Was this page helpful?
Please submit your feedback about this page through this
Alternatively, if you don't wish to complete the quick form, you can simply
indicate if you found this page helpful?
See existing feedback here.