sending an email from oracle client report (REPORT 6I)

[yacsil]

hello,
I have a problem sending an email from oracle client report (REPORT 6I)
my goal is to to send an email for each record of my request SQL , for example
:
select code, nom, prenom, satut , email
and this request returned :
a0005, algore, marc, 01-05-2003, a, algmar@cyber.net
b0200, brigard, fred, 16-07-2003, a, brifre@yahoo.fr
d0435, dupuis, roy, 01-09-2003, a, duproy@videotron.ca
then I want to send :
for algmar@cyber.net an email containing the informations : a0005, algore,
marc, 01-05-2003, a
for brifre@yahoo.fr an email containing the informations : b0200, brigard,
fred, 16-07-2003, a
....
I want to know how to do the send an email containning a specific record from a
request and the desname is a colonne from this request. And I will send an
email for each record record returned by the request.
thank you
yacine silhadi
yacine.silhadi@notarius.com

 

[sem]

I think that you don't need Reports at all: this may be done by UTL_SMTP package.

Regards, Dima

 

[yacsil]

I need report because all the data that I want to send is incoming from this report

Thank's

 

[sem]

The data is incoming from database first

Regards, Dima

 

[yacsil]

ya the data are incoming from the data base first.