A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.
File Extensions
If file is not Concurrent program (indicated by parent folder), then it is considered DB Objects (SQLs). File content is also further analyzed by populate process.
...
| Tip |
|---|
Make sure to end file with forward slash /, if last statement is Package, Trigger etc. FUNCTION, JAVA SOURCE, PACKAGE, PACKAGE BODY, PROCEDURE, TRIGGER, TYPE, TYPE BODY. Simple statements can be delimited by ; otherwise you need forward slashat end of statement but FUNCTION, JAVA SOURCE, PACKAGE, PACKAGE BODY, PROCEDURE, TRIGGER, TYPE, TYPE BODY needs / after it no matter where it is added in SQL file. Single or multiple line comments are also supported in input files. |
...