Posts

Send Email for Multiple Recipients with attachment from Oracle Database

PLSQL Procedure. DECLARE    i                          NUMBER              := 1;    j                          NUMBER              := 1;    p_to                       VARCHAR2 (100);    lv_smtp_server             VARCHAR2 (100)      := 'qgbl-smtprelay.les.com';    lv_domain                  VARCHAR2 (100);    lv_from                    VARCHAR2 (100)      := 'Donot reply-ARS@les.com';    v_connection               UTL_SMTP.connection;    c_mime_boundary   CONSTANT VARCHAR2 (256)      := '--AAAAA000956--';    v_clob                     CLOB;    ln_len                     INTEGER;    ln_index                   INTEGER;    ln_count                   NUMBER;    ln_code                    VARCHAR2 (10);    ln_counter                 NUMBER              := 0;    lv_instance                VARCHAR2 (100);    ln_cnt                     NUMBER;    ld_date                    DATE;    ld_msg                     VARCHAR2(100);    name_array   DBMS_SQL
Post a Comment
Read more

Create Custom CSV Download Button in Interactive report

Image
How to create custom CSV Download button in Interactive report? 1) Create Interactive report. 2) Create Custom download button. 3) Go to Button behavior Action and select Redirect to page in this application. 4) Click Target and Target type as Page in this application and page as which we have create button page no. like 6. 5) Click advance and type as " CSV " in Request. Another Method : 1) follow the up to 2nd  steps and select Redirect to URL in Action. 2) URL paste it as per screen shot and mention correct page no in the URL.
Post a Comment
Read more