Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLSQL-based method for capturing incoming POP3/IMAP email

636750Jun 4 2008 — edited Jun 6 2008
Hi,

I am trying to execute the following code for capturing mail from the POP server using PLSQL :
2020101

But at 1 point i.e.

loop
bytes := UTL_TCP.available( socket );

if bytes > 0 then
bytes := UTL_TCP.read_line( socket, line );
PIPE ROW( line );
end if;

exit when bytes = 0;
end loop;

In the above listed code, "bytes" is an integer. In this case, the "if" condition is never getting satisfied i.e. inspite of their being a mail in the POP server it takes bytes as 0. Can anyone tell me the reason for this ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2008
Added on Jun 4 2008
18 comments
1,944 views