PL/SQL (MOSC)

MOSC Banner

Email not received in correct format

edited Feb 24, 2010 4:48AM in PL/SQL (MOSC) 7 commentsAnswered ✓
 Hi Guys,

I am sending email from my oracle 11.1.0.6 database with an attachment. The attachment I receive it comes as in unknown format however I can open this file by saving on local disk using wordpad or MS Excel but I can't double click it.

Also the file is saved in correct CSV format on my linux box and it is readable.

Following is my code:

/* This procedure will generate the report and drop the file on linux box */

CREATE OR REPLACE PROCEDURE pr_dailySalesReport
AS
    l_length          NUMBER;
    l_line             CLOB;

    l_fileid          UTL_FILE.file_type;
    l_maxlinesize     BINARY_INTEGER := 32000;

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