Re: Oracle PL/SQL Help.

On Wed, 03 Apr 2002 23:46:05 GMT, "Ruvic News" <ruvic_at_hotmail.com> wrote:

>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,

If seems you don't have java installed.
The utl_tcp package is nothing more than a wrapper for java. Check out using the documentation the number of java object you have in dba_objects where object_type like 'JAVA%' You might need to run initjvm.sql from $ORACLE_HOME/rdbms/admin

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Apr 04 2002 - 11:12:09 CST