...
The password for the DB user defined in the db_user parameter.
variable_parser_reg_expr
...
| subtle | true |
|---|---|
| colour | Yellow |
| title | TODO |
This parameter defines a regular expression for parsing the dbms_output from the SQL script execution and sets the By default the JobSchedulerSQLPlus job defines a regular expression to parse console output from the execution of SQL Script and sets order parameters for subsequent job steps. For example, the dbms ouput DBMS_OUTPUT.PUT_LINE('SET order_date IS '|| v_order_date) displays SQL*Plus client stdout prompt SET period_prev IS ${PN_YEAR_PREV_PERIOD} displays the output on console SET order_date ; if period_prev is 20140915, it will it will be parsed by regular expression ^SETsexpression ^SETs+(\\s)\\s*ISs(.*)$ will result as order parameter order_date$ and return the period_prev="20140915" order parameter. All stdout statements matching the ^SETs+(\\s)\\s*ISs(.*)$ regular expression will be set as order_parameters.
Saving Database Connection Settings in a Parameter File
...
JobScheduler jobs can create and update JobScheduler Order parameters. The JobSchedulerSQLPlusJob can also pass on the result of SQL script execution i.e. calculated dates, parameters calculated from tables, etc. By default the JobSchedulerSQLPlus job defines a regular expression to parse console output from the execution of SQL Script and sets order parameters for subsequent job steps. For example, the SQL*Plus client stdout {code} prompt SET period_prev IS ${PN_YEAR_PREV_PERIOD};{code } displays the output on console; if period_prev is 20140915, it will be parsed by regular expression ^SETs+(\\s)\\s*ISs(.*)$ and return the period_prev="20140915" order parameter. All stdout statements matching the ^SETs+(\\s)\\s*ISs(.*)$ regular expression will be set as order_parameters.
...