Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Posts
    2

    Unanswered: Daily auto Email a report

    Database version 10.2.0

    I want to send daily auto email a report to CEO. Please guide me.

    thx in advance

    ali

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2007
    Posts
    2
    thx for reply.

    UTL_MAIL is used to send mail but how can I run report from pl/sql and attach the report result with mail.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    unwilling or incapable to Read The Fine Manual?

    Code:
    SQL> desc utl_mail
    PROCEDURE SEND
     Argument Name			Type			In/Out Default?
     ------------------------------ ----------------------- ------ --------
     SENDER 			VARCHAR2		IN
     RECIPIENTS			VARCHAR2		IN
     CC				VARCHAR2		IN     DEFAULT
     BCC				VARCHAR2		IN     DEFAULT
     SUBJECT			VARCHAR2		IN     DEFAULT
     MESSAGE			VARCHAR2		IN     DEFAULT
     MIME_TYPE			VARCHAR2		IN     DEFAULT
     PRIORITY			BINARY_INTEGER		IN     DEFAULT
    PROCEDURE SEND_ATTACH_RAW
     Argument Name			Type			In/Out Default?
     ------------------------------ ----------------------- ------ --------
     SENDER 			VARCHAR2		IN
     RECIPIENTS			VARCHAR2		IN
     CC				VARCHAR2		IN     DEFAULT
     BCC				VARCHAR2		IN     DEFAULT
     SUBJECT			VARCHAR2		IN     DEFAULT
     MESSAGE			VARCHAR2		IN     DEFAULT
     MIME_TYPE			VARCHAR2		IN     DEFAULT
     PRIORITY			BINARY_INTEGER		IN     DEFAULT
     ATTACHMENT			RAW			IN
     ATT_INLINE			BOOLEAN 		IN     DEFAULT
     ATT_MIME_TYPE			VARCHAR2		IN     DEFAULT
     ATT_FILENAME			VARCHAR2		IN     DEFAULT
    PROCEDURE SEND_ATTACH_VARCHAR2
     Argument Name			Type			In/Out Default?
     ------------------------------ ----------------------- ------ --------
     SENDER 			VARCHAR2		IN
     RECIPIENTS			VARCHAR2		IN
     CC				VARCHAR2		IN     DEFAULT
     BCC				VARCHAR2		IN     DEFAULT
     SUBJECT			VARCHAR2		IN     DEFAULT
     MESSAGE			VARCHAR2		IN     DEFAULT
     MIME_TYPE			VARCHAR2		IN     DEFAULT
     PRIORITY			BINARY_INTEGER		IN     DEFAULT
     ATTACHMENT			VARCHAR2		IN
     ATT_INLINE			BOOLEAN 		IN     DEFAULT
     ATT_MIME_TYPE			VARCHAR2		IN     DEFAULT
     ATT_FILENAME			VARCHAR2		IN     DEFAULT
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •