Hi All,
APEX 4.2.4. XE 11.2. Oracle Linux
A bit of advice please on the most practical approach to the following:
I have a requirement for an automated way to retrieve CSV attachments from an email server, and automatically load them into the system, then process them (using and existing PLSQL process).. Ive seen various threads on connecting to an email server (but not via Java on XE). I can't see anything much on retrieving the attachment from an email..
Alternatively, if this isn't possible, then the next option would be to dump the CSV files into a directory and have an automated process load the files into the Database.. Assuming this is a viable alternative, what would be the best approach? (Im not a Linux wizard, so some clues here would also be good..
Many Thanks
Richard