Dear experts,I have created a Oracle SQL VAR OBJECT to detect long-running jobs. I want to schedule this jobs for weekly run and get the result in a spreadsheet through email. I know how to send SQL VAR OBJECT result through CALL NOTIFICATION object printing the result (few rows) in the email body but I do not know how to get and send the SQL query result (more than 100 rows) into a spreadsheet through email. Can someone help me here
Kindly help me hereThanks in advanceThanksAbhay Chauhan
hellomaybe using this kind of command:: SET &RC2# = SEND_MAIL('people@domain.com',,'OBJET',' body of the mail','\\path_to_your_file\FIC_CSV','agent_oa','LOGIN.DEFAUT')