CREATE OR REPLACE PROCEDURE send_email (
 p_recipient IN VARCHAR2,
 p_message  IN VARCHAR2,
 p_subject IN VARCHAR2 default '',
 p_sender IN VARCHAR2 default 'shenjie@akey.net.cn')
IS
  crlf varchar2(2) := chr(13) || chr(10);
  v_mailhost varchar2(30) := '219.133.31.89';
  mail_conn utl_smtp.connection;
  msg varchar2(4000) := 'Date:' ||
     to_char(sysdate,'dd mon yy hh24:mi:ss') || crlf ||
  'From: ' || p_sender || '<'||p_sender||'>' ||crlf ||
  'Subject: '||p_subject || crlf||
  'To: '|| p_recipient || '<' || p_recipient || '>' ||crlf||
  p_message;
begin
  mail_conn := utl_smtp.open_connection(v_mailhost,25);
  utl_smtp.helo(mail_conn,v_mailhost);
  utl_smtp.mail(mail_conn,p_sender);
  utl_smtp.rcpt(mail_conn,p_recipient);
  utl_smtp.data(mail_conn,msg);
  utl_smtp.quit(mail_conn);
exception
  when others then
  dbms_output.put_line(dbms_utility.format_error_stack);
  dbms_output.put_line(dbms_utility.format_call_stack);
end;
/
  
exec send_email('shenjie@itownet.cn','happy week end');  
  
   Execute demo_mail.mail('shenjie@akey.net.cn','shenjie@akey.net.cn','ishenjie','shenjie');

hao
好像邮件的内容,显示不出来啊>>>

Great work!

is it sin?
[url=][/url]
[url=][/url]
[url=][/url]
[url=][/url] (c)

L:
[url=][/url]
[url=][/url]
[url=][/url]
[url=][/url] .

Hi!

I want to extend my SQL knowledge.
I red really many SQL resources and would like to
get more about SQL for my occupation as mysql database manager.

What would you recommend?

Thanks,
Werutz

Hi all!
Bye

There was this guy see.
He wasn't very bright and he reached his adult life without ever having learned "the facts".
Somehow, it gets to be his wedding day.
While he is walking down the isle, his father tugs his sleeve and says,

"Son, when you get to the hotel room...Call me"

Hours later he gets to the hotel room with his beautiful blushing bride and he calls his father,

"Dad, we are the hotel, what do I do?"

"O.K. Son, listen up, take off your clothes and get in the bed, then she should take off her clothes and get in the bed, if not help her. Then either way, ah, call me"

A few moments later...

"Dad we took off our clothes and we are in the bed, what do I do?"

O.K. Son, listen up. Move real close to her and she should move real close to you, and then... Ah, call me."

A few moments later...

"DAD! WE TOOK OFF OUR CLOTHES, GOT IN THE BED AND MOVED REAL CLOSE, WHAT DO I DO???"

"O.K. Son, Listen up, this is the most important part. Stick the long part of your body into the place where she goes to the bathroom."

A few moments later...

"Dad, I've got my foot in the toilet, what do I do?"

All greetings! I have fallen in love today))))
I wish to shout about love to all world !
Love this magnificent feeling))))

撗勇磐刃哇

腻忸麝

to: Admin - If You want to delete your site from my spam list, please sent url of your domain to my e-mail: stop.spam.today@gmail.com
And I will remove your site from my base within 24 hours
webmastegz

埋蝮镟轵

I very much love summer
Someone very much loves winter
I Wish to know whom more
For what you love winter?
For what you love summer? Let's argue

this.value

this.value

祟赅朦睇

标题

在此添加评论
表情符号:

称呼

邮箱地址（可选）

个人主页（可选）

记住我？