A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.
Object Type Identification
...
| Name | Description |
|---|---|
| .seq,tbl,idx,typ,tps,tpb,sql,pkh,plb,pks,pkb,pls,pck,fnc,trg,spc,bdy,prc | A file containing sql statements. Extensions may be customized using the EBS the SQL Extensions project property. |
...
| Name | Code |
|---|---|
| DB Objects (SQLs) | SQL |
Object Type Attributes
| Name | Code | Description | Default Value | Supported Values |
|---|---|---|---|---|
| Source | SOURCE | Object Source Location Type | SCM | SCM |
| Target Location | TARGET_LOCATION | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/sql/ | |
| Type | TYPE | DB Object Type | Generic SQL | |
| DB User Property | DB_USER | FlexDeploy property to use as the user to connect to the database with. | FDEBS_DB_USER | |
| DB Password Property | DB_PASSWORD | FlexDeploy property to use as the password for the DB User Property. | FDEBS_DB_PASSWORD | |
| Ignore Failure | IGNORE_FAILURE | Check if failure in file should be ignored. | If file contains WHENEVER SQLERROR CONTINUE case insensitively, this property will default to true. | |
| Fix SQL Syntax | 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. | True | |
| Target File Permission | FILE_PERMISSIONS | Permissions to apply to the file after it is deployed | Defaults to the project property FDEBS_FILE_PERMISSIONS |
Related Project Properties
| Name | Code | Description | Default Value |
|---|
| SQL Root Source Directory | FDEBS_SQL_ROOT_SOURCE_DIR | Source folder for sql and pls files (e.g. db). | sql |
| SQL Root Destination Directory | FDEBS_SQL_ROOT_DESTINATION_DIR | Target directory for SQL and PLS files (e.g. XXHR_TOP/admin/sql). | $<PROD_TOP>/patch/115/sql |
| SQL Extensions | FDEBS_SQL_EXTENSIONS | SQL file extensions in their order to process. | seq,tbl,idx,typ,tps,tpb,sql,pkh,plb,pks,pkb,pls,pck,fnc,trg,spc,bdy,prc See Database SQL file extensions and their order of process. |
| SQL Ignore Compile Errors | FDEBS_SQL_IGNORE_COMPILE_ERRORS | Ignore SQL compilation errors for all files in the project | false |
| SQL Retry Count | FDEBS_SQL_RETRY_COUNT | Retry count for SQLs and PL/SQLs. | 5 |
| File Permissions | FDEBS_FILE_PERMISSIONS | Target File Permission. Will be set to target file after deployment using chmod. eg: 755 | |
| Ignore Errors File List | FDEBS_IGNORE_ERRORS_FILE_LIST | List of files to ignore errors (e.g. DropHRTables.sql,*_ddl.sql). |
Sample Build Commands
N/A - Build commands not supported for this type.
...