Hi Team,
I am using DBMS_CLOUD_NOTIFICATION.SEND_DATA package to send email notification. The code is similar to the following code.
BEGIN
DBMS_CLOUD_NOTIFICATION.SEND_DATA(
provider => 'email',
credential_name => 'EMAIL_CRED',
query => 'SELECT * from emp',
params => json_object('recipient' value 'santosh@oracle.com',
'to_cc' value 'santosh@oracle.com',
'to_bcc' value 'santosh@oracle.com',
'subject' value 'Test subject',
'type' value 'txt',
'title' value 'mytitle',
'message' value 'This is the message',
'smtp_host' value 'smtp.email.example.com',
'sender' value 'noreply@oracle.com' )
);
END;
/
The email is triggering as expected but I want the query output to be displayed in a table format instead of an attachment.
Any suggestions please…