Query Result as a Table in WF FYI Notification
Hello,
I have a business requirement to list employees who were terminated in a particular period of time in a WF notification, I have used the below procedure, but I would like to replace the V_MESSAGE_LINE with a query result, i.e. a table.
Could anyone help me please?
DECLARE
V_NOTIFICATION_ID NUMBER := NULL;
V_FROM_USER_NAME VARCHAR2 (500) := 'SYSADMIN';
L_TO_USER_NAME VARCHAR2 (500) := 'SHATHA-TEST01';
V_SUBJECT_LINE VARCHAR2 (500) := 'Testing WF Notifications';
V_MESSAGE_LINE VARCHAR2 (500) := 'Hello';
BEGIN
V_NOTIFICATION_ID :=
WF_NOTIFICATION.SEND (UPPER (L_TO_USER_NAME),
'CS_MSGS',
'EXPANDED_FYI_MSG');
WF_NOTIFICATION.SETATTRTEXT (V_NOTIFICATION_ID,