PL/SQL (MOSC)

MOSC Banner

utl_smtp application/pdf, pdf attached show as characters

in PL/SQL (MOSC) 1 commentAnswered

    The code:


declare 

    v_bfile        BFILE;

     destoffset      INTEGER := 1;

     warning        INTEGER;

    v_length       INTEGER :=0; --T37250

    v_raw         RAW(57); --T37250

    v_buffer_size     INTEGER := 57; --T37250

    l_boundary      CONSTANT VARCHAR2(256) := '7D81B75CCC90D2974F7A1CBD'; --T37250

    first_boundary    CONSTANT VARCHAR2(256) := '--'|| l_boundary|| utl_tcp.crlf; --T37250

    last_boundary     CONSTANT VARCHAR2(256) := '--'|| l_boundary|| '--'|| utl_tcp.crlf; --T37250

    multipart_mime_type  CONSTANT VARCHAR2(256) := 'multipart/mixed; boundary="'|| l_boundary|| '"'; --T37250



    mailhost VARCHAR2(64) := 'smtp.email.us-ashburn-1.oci.oraclecloud.com';

   sender VARCHAR2(64) := 'picking@fasa.com.pa';

recipient VARCHAR2(64) := 'pablo.martinez@solusoft.com';

wallet_pwd VARCHAR2(64) := 'Manager1';

wallet_loc VARCHAR2(64) := 'file:/home/oracle/SMTP/';

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