Ê×Ò³ | Óʼþ×ÊѶ | ¼¼Êõ½Ì³Ì | ½â¾ö·½°¸ | ²úÆ·ÆÀ²â | ÓʼþÈ˲Š| Óʼþ²©¿Í | ÓʼþϵͳÂÛ̳ | Èí¼þÏÂÔØ | ÓʼþÖÜ¿¯ | ÈȵãרÌâ | ¹¤¾ß
ÍøÂç¼¼Êõ | ²Ù×÷ϵͳ | Óʼþϵͳ | ¿Í»§¶Ë | µç×ÓÓÊÏä | ·´À¬»øÓʼþ | Óʼþ°²È« | ÓʼþÓªÏú | ÒÆ¶¯µçÓÊ | ÓʼþÈí¼þÏÂÔØ | µç×ÓÊéÏÂÔØ

Óʼþ·þÎñÆ÷

¼¼ÊõÇ°ÑØ | Exchange | Domino | Sendmail | Postfix | Qmail | IMail | MDaemon | Foxmail | James | Kerio | JavaMail | WinMail | Winwebmail | Merak | CMailServer | ½ðµÑ | ÆäËü | ÓʼþÓ뿪·¢ |
Ê×Ò³ > Óʼþ·þÎñÆ÷ > ÓʼþÓë³ÌÐò¿ª·¢ > ÀûÓÃUTL_MAIL·¢Ë͵ç×ÓÓʼþ > ÕýÎÄ

ÀûÓÃUTL_MAIL·¢Ë͵ç×ÓÓʼþ

³ö´¦£ºZDNET ×÷ÕߣºBob Watkins ʱ¼ä£º2006-6-20 10:06:00

´ÓOracle 8i¿ªÊ¼£¬Õâ¸öÊý¾Ý¿â¾ÍÒѾ­Äܹ»Í¨¹ýUTL_SMTP¹¤¾ß°ü·¢Ë͵ç×ÓÓʼþÁË¡£ËüÌṩµÄPL£¯SQL¹¤¾ß°üʵÏÖÁËRFCËù¶¨ÒåµÄ¼òµ¥Óʼþ´«ÊäЭÒ飨Simple Mail Transfer Protocol£¬SMTP£©¡£

Oracle 10g¼ÓÈëÁËÒ»¸öÐµĹ¤¾ß°ü¡ª¡ªUTL_MAIL£¬ËüÃâ³ýÁËÏÈǰµÄ¹¤¾ß°üËùÐèÒªµÄ¶îÍ⹤×÷¡£ËüÊǶÔÏÖÔÚÈÔÔÚʹÓõÄUTL_SMTPÍâ¼ÓµÄÒ»¸ö²ã¡£

ΪÁËÌå»áÒ»ÏÂUTL_MAILËù´øÀ´µÄ±ãÀû£¬ÏÖÔÚ¾ÍÈÃÎÒÃÇÏÈ¿´Ò»ÏÂÒÔǰµÄ´¦Àí·½·¨¡£UTL_SMTPÀïµÄº¯Êý»áÄ£·Âµç×ÓÓʼþ»á»°µÄ²½Öè¡£Ê×ÏÈ£¬ËüÊ×ÏÈÓÃUTL_SMTP.OPEN_CONNECTIONº¯ÊýÁ¬½Óµ½µç×ÓÓʼþ·þÎñÆ÷µÄÖ¸¶¨¶Ë¿ÚÉÏ¡£Ò»µ©³É¹¦½¨Á¢Á¬½Ó£¬¶à¸öº¯Êý»á±»°´Ë³Ðòµ÷ÓÃÀ´ÓëÓʼþ·þÎñÆ÷½øÐÐͨÐÅ¡£UTL_SMTP.HELO¹ý³Ì»áͨ¹ýÏò·þÎñÆ÷·¢ËÍHELO£¨¡°hello¡±£©ÏûÏ¢½¨Á¢Ò»¸öÓʼþ»á»°¡£È»ºóUTL_STMP.MAIL»áʶ±ð·¢ËÍÕߵĵç×ÓÓÊÏ䣬UTL_SMTP.RCPT»áʶ±ð½ÓÊÜÕߣ¬¶øUTL_SMTP.DATA»á·¢ËÍÏûÏ¢Îı¾¡£×îºó½ø³ÌÓÉUTL_SMTP.QUITÀ´½áÊø¡£

ͨ¹ýʹÓÃUTL_MAIL£¬Õâ¶à¸öº¯Êý±»ºÏ²¢³ÉÁËÒ»¸ö½Ð×öUTL_MAIL.SENDµÄ´æ´¢¹ý³Ì¡£ËüµÄ¸ñʽÊÇ£º

UTL_MAIL.SEND (sender, recipientlist, cc, bcc, subject,

Message, mime_type, priority)

Recipientlist¡¢ccºÍbcc²ÎÊý¶¼ÊÇÓöººÅ¸ô¿ªµÄ½ÓÊÜ¡¢³­ËͺÍÃܼþ³­ËÍÈËÔ±ÁÐ±í¡£·¢ËÍÕß¡¢Ö÷Ìâ¡¢ÏûÏ¢ºÍmime_type²ÎÊý¶¼Êǵ¥¸öÏîÄ¿×ֶΡ£ÉÏÊöËùÓÐÄÚÈݶ¼±»¶¨ÒåΪVARCHAR2¡£×îºóÒ»¸ö²ÎÊýpriorityÊÇÒ»¸öÓÃÀ´¶¨ÒåÏûÏ¢ÓÅÏȼ¶±ðµÄPLS_INTEGER¡£

Õâ¸ö¹¤¾ß°ü»¹´øÓÐÁ½¸ö´¦Àí¸½¼þµÄ¹ý³Ì¡£SEND_ATTACH_RAWºÍSEND_ATTACH_VARCHAR2¹ý³ÌÓëSENDÀàËÆ£¬µ«ÊÇ´øÓÐÒ»¸ö¶îÍâµÄ²ÎÊý£¬ÓÃÀ´·¢Ë͸½¼þµÄRAW»òÕßVARCHAR2ÀàÐÍ¡£

×¢£ºÔÚĬÈÏÇé¿öÏ£¬´¦ÓÚ°²È«µÄ¿¼ÂÇUTL_MAILûÓб»ÅäÖá£Äã±ØÐëÒÔSYSµÄÉí·ÝÁ¬½Ó½øÐа²×°£¬È»ºóÖ´ÐÐ$ORACLE_HOME/rdbms/adminĿ¼ÏµÄutlmail.sql½Å±¾¡£´ËÍ⣬Ä㻹±ØÐëÅäÖÃÒ»¸ö³õʼ»¯²ÎÊý¡ª¡ªSMTP_OUT_SERVER£¬Ö¸ÏòÒ»¸ö³öÕ¾SMTP·þÎñÆ÷£¨ºÍUTL_STMP²»Í¬£¬ËüûÓÐÔÚº¯Êý²ÎÊýÀïÖ¸¶¨£¬ËùÒÔ±ØÐëÔ¤¶¨Ò壩¡£

Ïà¹ØÎÄÕ ÈÈÃÅÎÄÕÂ
  • ˼¿ÆIronPort·¢²¼Ðµç×ÓÓʼþ°²È«É豸
  • ¹È¸èÌṩµÄµç×ÓÓʼþ´æµµÊ±¼äÑÓ³¤ÎªÊ®Äê
  • HotmailÌáʾ£ºÈçºÎ·À·¶µç×ÓÓʼþÆÛÕ©
  • IAB¹«²¼µç×ÓÓʼþÊý¾Ý¹ÜÀí×î¼Ñʵ¼ù
  • µç×ÓÓʼþ´æµµµÄ¡°ÎÄ»¯Î¶¡±
  • Windows 7½«È¡Ïûµç×ÓÓʼþ¼°ÕÕÆ¬±à¼­Èí¼þ
  • ÖÐСÆóÒµÀ­¶¯Íйܵç×ÓÓʼþ·þÎñѸÃÍÔö³¤
  • MIMOSA½ø¾ü¹úÄÚÏÂÒ»´úµç×ÓÓʼþ¹éµµÊг¡
  • Èø°à˹Öйú·¨°¸Íƶ¯µç×ÓÓʼþ¹éµµ·¢Õ¹
  • ¿ÆÑ§¼Ò¿ª·¢³ö¿É×Ô¶¯±ðµç×ÓÓʼþÈö»ÑµÄÈí¼þ
  • ½µµÍ¾Ó¸ß²»Ïµĵç×ÓÓʼþ¹éµµ´æ´¢³É±¾
  • ÈçºÎ²ÅÄÜÀí˳µç×ÓÓʼþ¹ÜÀí
  • ÓÃC++ BuilderʵÏÖµç×ÓÓʼþȺ·¢
  • ÓÃCdontsʵÏÖ·¢ËÍEmail
  • JmailµÄÖ÷Òª²ÎÊýÁбí
  • ASP.NET 2.0·¢Ë͵ç×ÓÓʼþÈ«ÃæÆÊÎöÖ®¶þ
  • VC++ SMTPЭÒéµç×ÓÓʼþ´«ËÍÆÊÎö
  • ͨ¹ýsinaµÄsmtpÑéÖ¤µÄJava·¢ËÍÓʼþÔ´´úÂë
  • ASP.NET 2.0Öз¢Ë͵ç×ÓÓʼþÆÊÎöÖ®Ò»
  • ÔÚAsp.NetÖÐʹÓÃSmtpMail·¢ËÍÓʼþµÄ·½·¨
  • .NET»·¾³ÏÂEmailµÄ¼¼Êõ½éÉÜ
  • ASP.NET 2.0·¢Ë͵ç×ÓÓʼþÖдæÔÚµÄÎÊÌâ
  • ÓÃASPÅжÏEmailµØÖ·ÊÇ·ñÓÐЧ
  • IISÈçºÎ½ÓÊÕServerXMLHTTP´«¹ýÀ´µÄ±àÂë×Ö·û?
  • ×ÔÓÉ¹ã¸æÇø
    ¡¡
     
    ×îÐÂÈí¼þÏÂÔØ
  • ORF Enterprise Edition 4.2 Õýʽ°æ
  • WinWebMail 3.7.7.3 ±ê×¼°æ
  • WinWebMail 3.7.7.3 ÆóÒµ°æ
  • BMailì÷ÓÊ
  • Merak Email Server for Windows 9.3.1..
  • Merak Email Server for Linux 9.3.1 ¼..
  • Merak Email Server 9.3.1 For Windwos..
  • AXIGEN Mail Server 6.1.1 for Windows
  • AXIGEN Mail Server 6.1.0 for Linux
  • ADModify.NETÏÂÔØ
  • symantec10.1»ù±¾°²×°¼°ÅäÖÃÊÓÆµ½Ì³Ì
  • Backup Exec System RecoveryÖ®±¸·ÝÊÓÆ..
  • ½ñÈÕÓʼþ¼¼ÊõÎÄÕÂ
  • ÃÀ´óѧÉúÇÖÈëÅåÁÖÖݳ¤¸öÈËÓʼþÕË»§±»´þ²¶
  • ˼¿ÆIronPort·¢²¼Ðµç×ÓÓʼþ°²È«É豸
  • Éî¸û"Èí¼þ+·þÎñ" ΢Èí300³ÇÊÐѲչî£ÓÊ
  • ´ÓºÚ¿Í³£Óù¥»÷Êֶο´WEBÓ¦Ó÷À»¤
  • ÏûÏ¢ÈËʿ͸¶ÑÅ»¢ÓëAOLºÏ²¢Ï¸½Ú½«ÓÚ±¾Ô..
  • ¹È¸èÌṩµÄµç×ÓÓʼþ´æµµÊ±¼äÑÓ³¤ÎªÊ®Äê
  • ÑÅ»¢½«ÔÚÓÊÏä·þÎñÖÐÕûºÏаæÔÚÏßÈÕÀú
  • 9ÔÂÀ¬»øÓʼþ×ÜÁ¿¼õÉÙ ÓëISPµ¹±ÕÓйØ
  • À¬»øÓʼþ·¢Õ¹µÄËÄ´óÇ÷ÊÆ
  • º«¹úÒéÔ±³ÆÖйúºÚ¿Íð³äÇàÍß̨·¢ËͲ¡¶¾..
  • VistaÄÑ³ÉÆøºò Windows XPÊÙÃü±»ÑÓ³¤
  • ÈüÃÅÌú¿ËÉý¼¶DLP²úÆ·¼°·´À¬»øÓʼþÍø¹Ø
  • ×îÐÂרÌâ
  • Sendmail ÓʼþϵͳÅäÖÃ
  • ×齨Exchange 2003Óʼþϵͳ
  • Windows Server 2008 רÌâ
  • ORF ·´À¬»øÓʼþϵͳ
  • Exchange Server 2007 רÌâ
  • ISA Server 2006 ½Ì³ÌרÌâ
  • Windows Vista ¼¼ÊõרÌâ
  • ¡°ºÚÝ®¡±£¨BlackBerry£©×¨Ìâ
  • ÒÆ¶¯µç×ÓÓʼþרÌâ
  • Apache James רÌâ
  • IMail Server ²Ù×÷Ö¸ÄÏ
  • ISA Server 2004 ʹÓÃרÌâ
  • ·ÖÀർº½
    ÓʼþÐÂÎÅ×ÊѶ:
    ITÒµ½ç | Óʼþ·þÎñÆ÷ | ÓʼþȤÎÅ | ÒÆ¶¯µçÓÊ
    µç×ÓÓÊÏä | ·´À¬»øÓʼþ|Óʼþ¿Í»§¶Ë|ÍøÂ簲ȫ
    ÐÐÒµÊý¾Ý | ÓʼþÈËÎï | ÍøÕ¾¹«¸æ | ÐÐÒµ·¨¹æ
    ÍøÂç¼¼Êõ:
    ÓʼþÔ­Àí | ÍøÂçЭÒé | ÍøÂç¹ÜÀí | ´«Êä½éÖÊ
    Ïß·½ÓÈë | ·ÓÉ½Ó¿Ú | Óʼþ´æ´¢ | »ªÎª3Com
    CISCO¼¼Êõ | ÍøÂçÓë·þÎñÆ÷Ó²¼þ
    ²Ù×÷ϵͳ:
    Windows 9X | Linux&Uinx | Windows NT
    Windows Vista | FreeBSD | ÆäËü²Ù×÷ϵͳ
    Óʼþ·þÎñÆ÷:
    ³ÌÐòÓ뿪·¢ | Exchange | Qmail | Postfix
    Sendmail | MDaemon | Domino | Foxmail
    KerioMail | JavaMail | Winwebmail |James
    Merak&VisNetic | CMailServer | WinMail
    ½ðµÑÓʼþϵͳ | ÆäËü |
    ·´À¬»øÓʼþ:
    ×ÛÊö| ¿Í»§¶Ë·´À¬»øÓʼþ|·þÎñÆ÷¶Ë·´À¬»øÓʼþ
    Óʼþ¿Í»§¶ËÈí¼þ:
    Outlook | Foxmail | DreamMail| KooMail
    The bat | À×Äñ | Eudora |Becky! |Pegasus
    IncrediMail |ÆäËü
    µç×ÓÓÊÏä: ¸öÈËÓÊÏä | ÆóÒµÓÊÏä |Gmail
    ÒÆ¶¯µç×ÓÓʼþ:·þÎñÆ÷ | ¿Í»§¶Ë | ¼¼ÊõÇ°ÑØ
    ÓʼþÍøÂ簲ȫ:
    Èí¼þ©¶´ | °²È«ÖªÊ¶ | ²¡¶¾¹«¸æ |·À»ðǽ
    ¹¥·À¼¼Êõ | ²¡¶¾²éɱ| ISA | Êý×ÖÇ©Ãû
    ÓʼþÓªÏú:
    EmailÓªÏú | ÍøÂçÓªÏú | ÓªÏú¼¼ÇÉ |ÓªÏú°¸Àý
    ÓʼþÈ˲Å:ÕÐÆ¸ | Ö°³¡ | Åàѵ | Ö¸ÄÏ | Ö°³¡
    ½â¾ö·½°¸:
    Óʼþϵͳ|·´À¬»øÓʼþ |°²È« |ÒÆ¶¯µçÓÊ |Õбê
    ²úÆ·ÆÀ²â:
    Óʼþϵͳ |·´À¬»øÓʼþ |ÓÊÏä |°²È« |¿Í»§¶Ë
    ¹ã¸æÁªÏµ | ºÏ×÷ÁªÏµ | ¹ØÓÚÎÒÃÇ | ÁªÏµÎÒÃÇ | ·±ówÖÐÎÄ
    °æÈ¨ËùÓУºÓʼþ¼¼Êõ×ÊÑ¶Íø©2003-2007 www.5dmail.net, All Rights Reserved
    www.5Dmail.net Web Team   ÔÁICP±¸05009143ºÅ