Oracle PL/SQL Help.

From: Ruvic News <ruvic_at_hotmail.com>
Date: Wed, 03 Apr 2002 23:46:05 GMT
Message-ID: <1vMq8.2513$Wv2.2219@nwrddc02.gnilink.net>

Guys,

Received the this error during a UTL_TCP.GET_LINE call. Did anybody experienced this problem before and how did you fix this problem.

Oracle Error Message : ERROR : ORA-29531: no method read in class oracle/plsql/net/TCPConnection

Code :

DECLARE
  c utl_tcp.connection; -- TCP/IP connection to the Web server   ret_val pls_integer;
BEGIN

  c := utl_tcp.open_connection(remote_host => 'host',
                               remote_port =>  8888,
                               charset     => 'US7ASCII');  -- open connection

  ret_val := utl_tcp.write_line(c, 'GET / HTTP/1.0'); -- send HTTP request   ret_val := utl_tcp.write_line(c);
  BEGIN
    LOOP
      dbms_output.put_line(utl_tcp.get_line(c, TRUE)); -- ERROR *****     END LOOP;
  EXCEPTION
    WHEN utl_tcp.end_of_input THEN
      NULL; -- end of input
  END;
  utl_tcp.close_connection(c);
END; Thanks, Received on Wed Apr 03 2002 - 17:46:05 CST