procedure to generate email with attached file

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Thu, 12 Jun 2008 10:20 am

Hello all, is there a way to aexar 1 file to send 1 email via procedure of Bank?

I wanted to run 1 query with sales month for the sales supervisors is? can be 1 txt file even I thank you
eduardo
Location: sp

Sempre há algo a aprender....

Poston Fri, 13 Jun 2008 10:14 am

To attach the file via procedure of Bank, believe the file will have to be inside the server ... what would make your routine inviavel, because, every day, another routine would have to generate the file into the server.

The idea is good, but I don't know if it's possible for the explanation above.
Mainly, I think via procedure it is not possible to attach, via forms is possible.
RodrigoValentim
Location: Salvador - BA

Rodrigo Valentim
Analista de Sistemas
Oracle Developer

Campanha: Faça uma pesquisa antes de perguntar!!!

Poston Mon, 16 Jun 2008 12:10 pm

Hello.

If your version of Oracle's 10 g or higher, you can use the package UTL_MAIL, remembering that she is not installed in default.
To install it you must execute as SYSTEM ultmail.sql and prvtmail.plb scripts in the $ORACLE _ HOME/rdbms/admin. After installed, you should set the parameter, SMTP_OUT_SERVER putting the IP and port from your mail server.

How to use the package, has a nice example in the forum.

viewtopic.php?t=1911&highlight=utlmail Hugs
carlosmilan
Location: Vargem Grande do Sul - SP

Carlos Milan
Analista de Sistemas


  • See also
    Replies
    Views
    Last Post


        Return to PL/SQL

        Who is online

        Users browsing this forum: Bing [Bot] and 11 guests