DownloadImage
Downloads the image from the FileWebImage field of an attachments resource.
Stored Procedure-Specific Information
The Oracle Fusion Cloud SCM API exposes certain attachment tables which contain the 'FileContent' and 'FileWebImage' fields. The content of these attachments can be downloaded using this stored procedure.
This procedure only supports downloading PNG images.
Required Parameters: AttachmentTableName, KeyNames, and KeyValues.
You must supply the attachment table's name, the Id column's name, and values as commma-separated strings. Note: The order of the values must match the corresponding key names.
EXEC DownloadImage AttachmentTableSchemaName='SCMCommon', AttachmentTableName='TableName', KeyNames = 'Name1,Name2', KeyValues='1,2';
EXEC DownloadImage AttachmentTableSchemaName='SCMCommon', AttachmentTableName='TableName', KeyNames = 'Name1,Name2', KeyValues='1,2', DownloadPath='C://Image.png';
You can also have the attachment content streamed into an output stream using the FileStream parameter.
Input
| Name | Type | Accepts Output Streams | Description |
| AttachmentTableSchemaName | String | False | The schema name of the attachment table. |
| AttachmentTableName | String | False | The attachment table's name. |
| KeyNames | String | False | List of comma-separated names of Id columns of the table name. Must be set in the same order as they appear in the table. |
| KeyValues | String | False | List of comma-separated values of Id columns of the table name. Must have the same order as KeyNames. |
| DownloadPath | String | False | Full file path of the image to download content into. For example: C:\Image.png |
| FileStream | String | True | Instance of an output stream where image data is written to. Only used if DownloadPath is not provided. |
Result Set Columns
| Name | Type | Description |
| Success | String | Execution status of the stored procedure. |
| FileData | String | Base64 encoded content of the downloaded image. Returned only if DownloadPath and FileStream are not supplied. |