Oracle Issues & Resolutions

 While using conventional PLSQL procedure, the Oracle UTL_SMTP.Write_Data have input parameter as varchar2 -- which has a limit of size, so while emailing large content through single Write_data, is not possible. so the solution is to pass the data to email through chunks. Below is the old Procedure. (Having trouble with size) CREATE OR REPLACE PROCEDURE SUPPORT_PORTAL.send_mail_html_new (    p_to            IN   VARCHAR2,    p_from          IN   VARCHAR2,    p_cc            IN   VARCHAR2,    p_bcc           IN   VARCHAR2,    p_subject       IN   VARCHAR2,    p_text_msg      IN   VARCHAR2 DEFAULT NULL,    p_attach_name   IN   VARCHAR2 DEFAULT NULL,    p_attach_mime   ...

Method #1  create table support_portal.dms_det2 as select * from dms_det@LINK_218 UPDATE support_portal.dms_det a    SET CONTENTSS =            (SELECT CONTENTSS               FROM dms_det2              WHERE     DOCID = a.DOCID                    AND DOCREVID = a.DOCREVID                    AND FILENO = a.FILENO                    AND FILEID = a.FILEID) Method#2 UPDATE support_portal.dms_det a    SET CONTENTSS =            (SELECT CONTENTSS               FROM dms_det@LINK_218              WHERE     DOCID = a.DOCID                    AND DO...