Re: Oracle PL/SQL Help.

From: Ruvic News <ruvic_at_hotmail.com>
Date: Thu, 04 Apr 2002 18:53:10 GMT
Message-ID: <qi1r8.3922$kL3.3229@nwrddc03.gnilink.net>

Sybrand,

Thanks for the reply.

Java is currently installed on my machine and if i try to login using sqlplus .. it gives me the following text...

Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

---

Also i counted my dba_objects using

select count(1) from
dba_objects
where object_type like 'JAVA%'

and result was 10,522 records.

---

using SQL

select owner,object_name,object_type from dba_objects
where upper(object_name) like '%TCP%'

the result .....

OWNER OBJECT_NAME OBJECT_TYPE
GOLD com/oroinc/net/TimeTCPClient JAVA CLASS GOLD com/oroinc/net/EchoTCPClient JAVA CLASS

GOLD /de07a6e1_DiscardTCPClient JAVA CLASS
GOLD /9bba6fa6_DaytimeTCPClient JAVA CLASS
GOLD /776ada1_CharGenTCPClient JAVA CLASS

PUBLIC UTL_TCP SYNONYM
PUBLIC oracle/net/nt/TcpNTAdapter SYNONYM PUBLIC oracle/aurora/mts/TcpEndpoint SYNONYM

PUBLIC /ec97e8aa_SmartTcpListener SYNONYM
PUBLIC /e778b518_TCPEndpointFQDN SYNONYM
PUBLIC /e3343184_SmartTcpSocket SYNONYM
PUBLIC /d70c43a_TCPConnection SYNONYM
PUBLIC /d507ca33_TcpConnection SYNONYM
PUBLIC /beb18c22_TcpListener SYNONYM
PUBLIC /9da485c0_TcpConnectionFactory SYNONYM
PUBLIC /84faa759_TCPChannel SYNONYM
PUBLIC /72e8b65e_TcpConnectionFactory SYNONYM
PUBLIC /699b9ddd_TCPTransportConnecti SYNONYM
PUBLIC /6510d952_TcpSocket SYNONYM
PUBLIC /63dab045_TCPEndpoint SYNONYM
PUBLIC /375c3e3_TCPChannelReaper SYNONYM
PUBLIC /30435b07_TCPTransport SYNONYM

SYS UTL_TCP PACKAGE
SYS UTL_TCP PACKAGE BODY

SYS oracle/plsql/net/TCPConnection JAVA CLASS
SYS oracle/net/nt/TcpNTAdapter JAVA CLASS
SYS oracle/aurora/mts/TcpEndpoint JAVA CLASS
SYS /ec97e8aa_SmartTcpListener JAVA CLASS
SYS /e778b518_TCPEndpointFQDN JAVA CLASS
SYS /e3343184_SmartTcpSocket JAVA CLASS
SYS /d70c43a_TCPConnection JAVA CLASS
SYS /d507ca33_TcpConnection JAVA CLASS
SYS /beb18c22_TcpListener JAVA CLASS
SYS /9da485c0_TcpConnectionFactory JAVA CLASS
SYS /84faa759_TCPChannel JAVA CLASS
SYS /72e8b65e_TcpConnectionFactory JAVA CLASS
SYS /699b9ddd_TCPTransportConnecti JAVA CLASS
SYS /6510d952_TcpSocket JAVA CLASS
SYS /63dab045_TCPEndpoint JAVA CLASS

SYS /375c3e3_TCPChannelReaper JAVA CLASS SYS /30435b07_TCPTransport JAVA CLASS

Anymore suggestion ..?

regards,
Victor

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:582pau8v52pf2bhoo2bm2lerikugohagv6_at_4ax.com...
> 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 - 12:53:10 CST