PLSQL based method to capture emails from POP server
Home > IT Answers > Networking > PLSQL based method to capture emails from POP...
Monk
10 pts.
0
Q:
PLSQL based method to capture emails from POP server
TCP, POP3, PL/SQL, UTL-TCP
I am using UTL_TCP package of PLSQL. I am able to connect to the POP server but I am unable to retrieve any email content. Using the UTL_TCP.available() method, I am getting the returned number of bytes as Zero inspite of their being an email. I tested the telnet commands againt the POP server & they run perfectly fine ans also I am able to retrieve the emails using Telnet.
ASKED: Jun 5 2008  7:21 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29855 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Hello Monk.
The first thing you should receive after a succesful connection, as you already know, is something like "'+OK ... POP3 ... ready", not email content.

Are you receiving it ?

It would be useful to see your code.

Regards,
Last Answered: Jun 5 2008  10:42 PM GMT by Carlosdl   29855 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Winners of the “Best Questions” t-shirt contest - ITKE Community Blog   0 pts.  |   Jun 9 2008  7:16PM GMT

[...] Bobkberg DLM2007 Koohiisan Nanopit Monk [...]

 

Carlosdl   29855 pts.  |   Sep 22 2008  8:28PM GMT

I tried this a few months after answering this question, and I faced the same problem: 0 bytes when calling UTL_TCP.available(). The reason: I was calling UTL_TCP.available() too early, because I needed to wait for the POP server response to my previous message, before calling the ‘available’ function.

 
0