Re: Scheduling the mail sending attachments using PL/SQL

From: Jim Kennedy <jim>
Date: Thu, 27 Jul 2006 17:11:47 -0700
Message-ID: <JISdnTEBs8gNyFTZnZ2dnUVZ_radnZ2d@comcast.com>

"HK" <harikishan.b_at_gmail.com> wrote in message news:1154012222.258354.121930_at_m79g2000cwm.googlegroups.com...
> Hi I need to send an updated select statement by email from PL/SQL.
> This should be automated process. I am able to send email from PL/SQL
> but not sure how to schedule this as automated process. also can any
> one help me how to send attachments using pl/sql mails.
>
> Thanks
> HK
>

Use the dbms_jobs package.
Jim Received on Thu Jul 27 2006 - 19:11:47 CDT

This message: [ Message body ]
Next message: Mark D Powell: "Re: sysdate without time"
Previous message: Mark D Powell: "Re: Username of a user connecting to a database via an application server"
In reply to: HK: "Scheduling the mail sending attachments using PL/SQL"
Next in thread: DA Morgan: "Re: Scheduling the mail sending attachments using PL/SQL"
Reply: DA Morgan: "Re: Scheduling the mail sending attachments using PL/SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US