E-FTP: How to Get Multiple Attachments from Remote FTP Server With/Without a Wildcard (*) in the Filename ? (Doc ID 2961790.1)

Last updated on JULY 17, 2023

Applies to:

Goal

In the Peoplebook, It is stated that the wildcard * should not be used in the file path/name. In that case, how do we get a file when the file name is not constant or when we need to fetch multiple files, using a wildcard (ex: with a file prefix like abc*.csv to fetch all files starting with abc with the extension of csv)?
How to use getattachment() function to get files from a remote FTP server, using a wildcard (*) in the file name.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.