A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.
Object Type Identification
...
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM | SCM |
| Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/sql/ | |
| Type | DB Object Type | Generic SQL | |
| DB User Property | FlexDeploy property to use as the user to connect to the database with. | FDEBS_DB_USER | |
| DB Password Property | FlexDeploy property to use as the password for the DB User Property. | FDEBS_DB_PASSWORD | |
| Ignore Failure | Check if failure in file should be ignored. @Since 4.6.0.3 | If file contains WHENEVER SQLERROR CONTINUE, this property will default to true. | |
| Fix SQL Syntax | If there is need to add / at the end of file, FlexDeploy will add it at deploy time. For example, if there is program block as last statement, we need / and new line after it. @Since 4.6.0.3 | True |
Related Project Properties
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
cp "$SOURCE_FILE" "$XXHR_TOP/patch/115/sql/"; cd "$XXHR_TOP/patch/115/sql/" sqlplus $FDEBS_DB_USER/$FDEBS_DB_PASSWORD <<EOF set define off @$XXHR_TOP/patch/115/sql/XXHR@XXHR_BIPUB_REP_PKG.seq . SHOW ERRORS exit sql.sqlcode EOF |
...
| Tip |
|---|
|
...