You've to parse the message. I don't think there's an easy way to do this.but also we want to get the from address, subject, body, etc., and store this info in a table.
Did you consider using javamail?Thanks! I don't have any experience with Java, but it seems like this package can do exactly what I need, right? It can parse through the email and get the relevant parts that I need as well as being able to delete the email itself, correct?
See here for an example
utl_tcp.write_line(connection_string, 'DELE 1');
information that I want, right?
If your code is looking for a specific e-mail, it mayNot any more. I have to go through all of them. If the email's a returned undeliverable email, I just delete it. If the email's a genuine reply to the address that I'm checking, then I take all the relevant info (i.e., From, Subject, Body, etc.), add it to a table, then delete the email.
be the 11th or 32nd mail in the POP3 mail box. Using
What exactly is that doing?
I would however not implement a POP3 interface inMakes sense. We're not dealing with attachments, but I can still see how the 4k limit could be a problem.
Oracle as a pipeline table function. The SQL varchar2
data type is restricted to 4000 bytes - and this will
be a severe limitation dealing with some e-mails
Using a plain PL/SQL interface and writing the e-mailMakes sense. And actually, after reading through that RFC, taking out all the tstring and pipe stuff makes that code pretty readable and straightforward now.
into a CLOB would be the correct approach.