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))))

撗勇磐刃哇

腻忸麝

Just wanted to say hello to all to a wonderfull community. Very informative great work.

looking forward to contribute to the community.

-------------------------------------------------------------------------
[url=http://www.pregnancychildcare.info]Pregnancy Week By Week[/url]

Just wanted to say hello to all to a wonderfull community. Very informative great work.

Can somebody recomend a good reliable hosting service for my website.

-------------------------------------------------------------------------
A young man in love thinks nothing is good enough for her except himself.
[url=http://www.pregnancychildcare.info]Week By Week Pregnancy[/url]

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

埋蝮镟轵

cartridge insurance car insurance health ins
torque car insurance
car insurance swinton
track car insurance
Look at great [url=http://car-insurance-hirx.netfirms.com/pennsylvania-car-insurance-laws.html]pennsylvania car insurance laws[/url]

london victoria car insurance
car insurance nova scotia
third party only car insurance
meloche monnex car insurance
shelia's wheels car insurance
el paso car insurance
no frills car insurance
car insurance oil
car insurance price quote
hire car insurance
car insurance quotes for students
mercury car insurance quote
car insurance quote arizona
car insurance kirksville
car insurance phoenix
accident car insurance report
audi tt car insurance
car insurance only uk

[url="http://www.adult-vids.ru/?adv=glamyr"]衔型

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

It would be much simpler if one could apply a test of an X percent [url=http://www.tuchmet.info/colors-for-car.html]colors for car[/url] of a loss of Y percent or greater.

this.value

西屙黐url=http://www.unitart.net][/url] 镱眇噔桦囫

祟赅朦睇

[url=http://www.article-soumission.com/?2637-acheter-viagra-generique-en-ligne-09euro-par-comprime]viagra[/url] impaired may be valuable

This Thread will focus on how you can make money online.
Cash Crate is a rather large and popular get paid to complete offers and survey site that pays its members to participate in contests, complete surveys, and refer members.
When you join Cash Crate, you are able to complete surveys and earn real cash, which is good for people looking for work online....or better yet, to make a living!!!

I make $1600-$2200 A Month with a few GPT Sites, but there's lots of people making $2000+ per month with JUST CASHCRATE!!
Cash Create was started in early 2006 as a way to help people earn cash. There is no doubt that this is can be ranked within the top five paying GPT/SURVEY sites on the Internet.

Quick Look:
How to Get Paid - Complete offers, surveys, and participate in contests to win cash.
Payment Method - Check
When Paid - Once per month (the 15th to 20th) when you have reached $20.
There are nearly 160 offers available ( more added every week or so ) for competion, ranging in value between $0.15 to $125, with the average offer valued at a few dollars. As stated elsewhere, you can rearrange them according to the type of offer you want to complete. Many of them are free, however the higher paying offers often require a small shipping fee or credit card to properly submit the article.

How to Earn
The site pays based on the number of offers and surveys you complete, at varying levels of payouts.
You may also use the "Cash Shopping" page to receive cash back for shopping at various online stores. It's quite simple when you realize the true potential that sites like Cash Crate have.

Referral Program
The referral program is a fairly basic, two-tier program, with 20% earnings for direct referrals and 10% for the people your direct referrals refer to the site.

Once you reach a certain level of referrals (normally active, United States/ UK/ Canada members who have reached a minimum of $10 worth of offers), you are promoted to a higher level of referral payout, a huge incentive to help you promote the site.

Bronze - 0 Active Referrals - 20% First Level, 10% Second Level
Silver - 50 Active Referrals - 25% First Level, 10% Second Level
Gold - 150 Active Referrals - 25% First Level, 15% Second Level
Platinum - 300 Active Referrals - 30% First Level, 15% Second Level
Elite - 500 Active Referals - 30% First Level, 20% Second Level

THIS IS THE BEST PART:
When you hit 50 Active referrals, you get the option to be paid $1.00 for each referral who complete's their first offer!!! It's how I make $20-$25 a day!!!

Here's an example:
10 Referrals making $10 per month = $100 for Cashcrate = $20 for you
100 Referrals making $10 per month = $1000 for Cashcrate = $250 for you
1000 Referrals making $10 per month = $10,000 for Cashcrate, $3,333 for you

Now let's say they all refer 1 member:
10 Referrals refer 1 member each = 20 Referrals
- Making $10 per month = $200 for CashCrate = $40 for you
100 Referrals refer 1 member each = 200 Referrals
- Making $10 per month = $2000 for CashCrate = $500 for you
1000 Referrals refer 1 member each = 2000 Referrals
- Making $10 per month = $20,000 for CashCrate = $6,666 for you!!!

=============================================

Now that you kinda have an idea on how it works, you sign up, refer some members, do some surveys, and make money!! it's that easy!!!
I find that making a blog/website with a review, and referral links is the easiest way to go!!... Just promote your blog, and it'll kind of take off itself!!
If you decide to sign up under me, PM me with any questions, and i'll be more than happy to help you out!!... MY REFERRALS GET SPECIAL TREATMENT!!!

SIGN UP UNDER ME --> http://get.1add.net

标题

在此添加评论
表情符号:

称呼

邮箱地址（可选）

个人主页（可选）

记住我？