oracle ·¢Óʼþ´íÎó
ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
mes_context in varchar2,to_user in varchar2)
is
Mail_Conn Utl_Smtp.Connection;
Msg Varchar2(4000);
Msg_Raw Raw(32767);
v_User Varchar2(20) :='user';
v_Pass Varchar2(20) :='pass';
v_Mailhost Varchar2(50) := 'stmp.126.com';
v_Mailport Integer := 25;
--Óʼþ·¢ËͲÎÊý
v_Senduser Varchar2(50) := 'fff_911@126.com';
Begin
Msg := 'Date:' || To_Char(Sysdate, 'dd mon yy hh24:mi:ss') || Utl_Tcp.Crlf;
Msg := Msg || 'from: ' || v_Senduser || ' <' || v_Senduser || '>' || Utl_Tcp.Crlf;
Msg := Msg || 'To: ' || to_user ||
Ïà¹ØÎÊ´ð£º
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøÒ³Ä£Ê½Æô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬
°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOrac ......
oracle text×öË÷Òýͬ²½µÄʱºò,Ó°Ïì²éѯÂð?ÈçºÎÖ¤Ã÷ÄØ?
ͬʱË÷Òýͬʱ²éѯ,²¢·¢½øÐÐͬһÌõ¼Ç¼
×Ô¼º¶¥Ò»¸ö
²Î¿¼£ºhttp://blog.csdn.net/fengzhu1008/archive/2009/01/15/3784853.aspx
text×öË÷Òý¡£ºÜ»áÓ°ÏìË ......