hi all,
saw various topics to send email through PL/SQL, I am searching for a client's requirement, they are using DB 11g (11.2) --its not XE-- they want:
( i knew we have to show full version but at the moment its not possible for me, hope you understand)
emails should automatically ( oracle job ) send
get/attach files from oracle directory - one by one -
recipients can be on any email server even public like: yahoo, outlook, gmail etc.
all email addresses are in client's information in a table.
they had a function to send email ( PL/SQL and JAVA mixed ) but they require to automate the process for their clients now.
I have no idea for mentioned above all 3 requirements, want any step by step approach guide ( with all required things ) to achieve their requirements including what I have to ask about it to have complete knowledge which necessary to do so?
reqards
EDIT: file in oracle directory can be mixed, PDF, XLS, XLSX, DOC, DOCX etc.