The files are attached to the extracted data by three
columns that are identified by a specific prefix:
- prefix_FILE_NAME (a VARCHAR2 column that includes the file name
- prefix_BLOB (a BLOB column that includes the file data)
- prefix_ATTRIB (a BLOB column that includes file attribute information)
Files are identified by the following
criteria:
- A file name format, which must include the name of a column with
data that forms part of a file name. Only CHAR, VARCHAR, NCHAR, and
NVARCHAR columns are valid. The name is generated by concatenating
values from the column data and specified literals.
- A path to search for files that match the file name format.
- The process selects the first file that matches the criteria.
For example, if the file name format includes the CUSTOMER_ID
column and the extension .txt, the process attaches the first file
named 123.txt in the search path for a row with the value 123 in the column.
To
define file attachments: