15 Comments

  1. LAKIDI RAVIKUMAR
    May 30, 2011 @ 1:20 pm

    This is good for communicating

  2. Rushikesh
    August 8, 2011 @ 7:34 pm

    UTL_MAIL.send_attach_varchar2 ( Does not exist , must be declared error facing )

  3. sonal
    September 6, 2011 @ 1:35 am

    Very nice…

  4. Sohrab
    September 18, 2011 @ 2:37 pm

    Hi,
    can you please explain what are the fields we need to change in the above procedure code?

    and what is the value i need to pass in the above two defined parameters?

  5. navin
    March 9, 2012 @ 10:48 am

    how can i capture request_id from conc_pgm to procedure?

  6. Piya
    August 24, 2012 @ 3:03 pm

    Good article. Let us know what value are you passing in variable p_parameter1

    Thanks,
    Piya

  7. shyam
    November 6, 2012 @ 10:30 am

    UTL_MAIL.send_attach_varchar2 procedure not exists….
    how can we send output thru’ mail?

  8. bhaskar
    January 8, 2013 @ 12:38 am

    UTL_MAIL.send_attach_varchar2 ( Does not exist , must be declared error facing )

  9. ravinder
    April 22, 2013 @ 4:31 pm

    UTL_MAIL.send_attach_varchar2 ( Does not exist , must be declared error facing

  10. William
    September 10, 2013 @ 8:19 pm

    Can anyone show me format to use for time?

    NULL, ?Time to start the program

  11. Kapil
    December 25, 2014 @ 10:54 pm

    Error(138,1): PLS-00201: identifier ‘UTL_MAIL.SEND_ATTACH_VARCHAR2’ must be declared

    Please assist

  12. Prudhvi
    December 26, 2014 @ 4:08 am

    Make sure UTL_MAIL package is available in Database. If not ask your DBA to install the package.

  13. Anonymous
    May 19, 2015 @ 9:13 am

    Hi,

    It shows invalid directory path.

  14. santhosh
    July 2, 2015 @ 7:14 pm

    You can use below scripts to install UTL_MAIL Package.

    sqlplus sys/
    SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
    SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb

  15. Venkat
    December 26, 2015 @ 10:31 pm

    Hi Prudhvi,

    It is nice article, Thank you.

    But one question, Is there any limitation of size ? I think UTL_MAIL only send attachments less than 32 KB.

Back to Top