UTL_SMTP and cursors NOT Working

[LadyDi02]

Hello experts,

It's my second post to the forum. No luck with the first one. Anyways.

I have created a stored procedure that uses a cursor and fetches data from a database table(select * from table_x) and sends an email to all the users in that database table. However the problem is that it is not sending emails to all the recipients in the table just one recipient. I am using the UTL_SMTP package and for some reason it does not issue an email to all the users in the table. Does this package allow that? Also, the package seems like it does not send emails to external users but works in my company if it is an internal user. Any ideas again. Thanks experts.

 

[oradba101]

Hi, LadyDi02

You could try the UTL_MAIL package. This is new to 10g.

Regards.


William Chadbourne
Oracle DBA

 

[LadyDi02]

Sorry William,

I should have bee more specific. I am using Oracle 9 and not 10 so I cannot use this functionality. Any ideas what I need to do with 9. Thanks again.

 

[BJCooperIT]

Please post your question in the 9i forum with an example of your code.

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus