Home » SQL & PL/SQL » SQL & PL/SQL » Using UTL_MAIL
Using UTL_MAIL [message #202902] Mon, 13 November 2006 04:24 Go to next message
karrisql.com
Messages: 7
Registered: November 2006
Junior Member
Hi,

I need to insert result of SELECT-statement into UTL_MAIL.SEND.message. How can I do it?

BR K
Re: Using UTL_MAIL [message #202928 is a reply to message #202902] Mon, 13 November 2006 05:56 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
As message parameter is varchar2, Why don't you write a pl/sql to get the SELECT result and pass that to UTL_MAIL.SEND?

By
Vamsi.
Re: Using UTL_MAIL [message #203176 is a reply to message #202928] Tue, 14 November 2006 03:31 Go to previous message
karrisql.com
Messages: 7
Registered: November 2006
Junior Member
Thanks a lot!!!!
Previous Topic: ORA-00979: not a GROUP BY expression
Next Topic: How to get values of parameters in exception block?
Goto Forum:
  


Current Time: Fri Dec 02 14:15:30 CST 2016

Total time taken to generate the page: 0.11283 seconds