Using Delimiter as ; for .csv file generated using UTL_SMTP
Hi All,
I have written pl/sql which emails with the attachment to respective users.Attachment is generated using sql query and if the column data has ,(comma) then the remaining value is displayed in the another grid of csv. Can any one help me how do I specify the delimiter as anything other than comma or how do I handle the , in the data. Please help.
Sample code used:
UTL_SMTP.write_data(smtp, '------_=_NextPart_001_01C87DCB.CD85F300' || utl_tcp.CRLF );
UTL_SMTP.write_data(smtp, 'Content-Disposition: attachment ; filename="Error_Data.csv"' || utl_tcp.CRLF );