PL/SQL (MOSC)

MOSC Banner

Using Delimiter as ; for .csv file generated using UTL_SMTP

edited Sep 9, 2015 5:23AM in PL/SQL (MOSC) 4 commentsAnswered ✓

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 );

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center