Home » SQL & PL/SQL » SQL & PL/SQL » Encountered : Ora 29259 while capturing emails from a Google POP server (Oracle 11g, Windows XP SP2)
Encountered : Ora 29259 while capturing emails from a Google POP server [message #328976] Mon, 23 June 2008 10:50 Go to next message
Monk27
Messages: 10
Registered: June 2008
Junior Member
Hi,

I am trying to retrieve emails from the Google POP server but I am unable to do so because of the error ORA 29259 - "end-of-input reached".

My code is as follows :

pop3_server CONSTANT VARCHAR2 (100) := 'pop.gmail.com';
pop3_port CONSTANT NUMBER := 110;
POP3_TIMEOUT CONSTANT NUMBER := 30;
pop3_ok CONSTANT VARCHAR2 (10) := '+OK';
e_pop3_error EXCEPTION;
socket UTL_TCP.connection;

-- Just to make sure there are no previously opened connections
UTL_TCP.close_all_connections;

-- open a socket connection to the POP3 server
socket :=
UTL_TCP.open_connection (remote_host => pop3_server,
remote_port => pop3_port,
tx_timeout => POP3_TIMEOUT,
CHARSET => 'US7ASCII'
);

I supply userid and password while querying the POP server.
Can somebody please explain me as to how should I proceed to establish a successful connection with the google pop server ?
Re: Encountered : Ora 29259 while capturing emails from a Google POP server [message #328977 is a reply to message #328976] Mon, 23 June 2008 10:54 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.faqs.org/rfcs/rfc1939.html

What does writing a POP mail client have to do with Oracle;
other than you are re-inventing the wheel & using the wrong tool for the job?

[Updated on: Mon, 23 June 2008 10:55] by Moderator

Report message to a moderator

Previous Topic: Summing Results of Other Columns
Next Topic: Need help with pl/sql
Goto Forum:
  


Current Time: Sun Dec 11 04:28:30 CST 2016

Total time taken to generate the page: 0.07711 seconds