RE: missing jaba libraries...

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Tue, 21 Nov 2000 15:02:00 -0500
Message-Id: <10687.122655@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C053F5.E8D99830
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

You should load java in your database.

Alex Hillman

-----Original Message-----
From: Javier Morales [mailto:Javier_at_infojobs.net] Sent: Tuesday, November 21, 2000 1:32 PM To: Multiple recipients of list ORACLE-L Subject: missing jaba libraries...

I try to execute one procedure that uses UTL_FILE and UTL_SMPT and I = get
this error...

SVRMGR> execute infojobs2.llansa_push_diario_archivos;

ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at "SYS.UTL_TCP", line 533
ORA-06512: at "SYS.UTL_TCP", line 199
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "INFOJOBS2.LLANSA_PUSH_DIARIO_ARCHIVOS", line 253
ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at line 2

I did launch the scripts initjvm.sql, initplsj.sql and made a javaload = of
plsql.jar file...

any suggestions??

Javier Morales - javier_at_infojobs.net
Administraci=F3n Bases de Datos Oracle - InfoJobs.net Tel. +34 902 10 60 90 Ext. 2067
Fax. +34 (93) 580 56 60
=20

-----Mensaje original-----
De: Raj Gopalan [mailto:raj.gopalan_at_netdecisions.co.uk] Enviado el: martes 21 de noviembre de 2000 18:46 Para: Multiple recipients of list ORACLE-L Asunto: DBMS_JOB

Hi all

I need to schedule a procedure using dbms_job.=20

I created it using the following script.

declare

jobno number;
begin

dbms_job.submit(jobno,'SP_MANUAL_REPLICATION;', = sysdate,'sysdate+1');

commit;
end;

For some reason it not running at all.=20

Any thoughts?

TIA Raj
--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Raj Gopalan
INET: raj.gopalan_at_netdecisions.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Javier Morales
INET: Javier_at_infojobs.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

------_=_NextPart_001_01C053F5.E8D99830
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0">

<TITLE>RE: missing jaba libraries...</TITLE>
</HEAD>
<BODY>

You should load java in your database.

Alex Hillman

-----Original Message----- From: Javier Morales [<A = HREF=3D"mailto:Javier_at_infojobs.net">mailto:Javier_at_infojobs.net</A>]</FON= T>

<BR><FONT SIZE=3D2>Sent: Tuesday, November 21, 2000 1:32 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: missing jaba libraries...</FONT>
</P>
<BR>

I try to execute one procedure that uses  = UTL_FILE and UTL_SMPT and I get
 this error...

SVRMGR> execute =
infojobs2.llansa_push_diario_archivos; ORA-29540: class oracle/plsql/net/TCPConnection does = not exist
 ORA-06512: at "SYS.UTL_TCP", line = 533
 ORA-06512: at "SYS.UTL_TCP", line = 199
 ORA-06512: at "SYS.UTL_SMTP", line = 99
 ORA-06512: at "SYS.UTL_SMTP", line = 121
 ORA-06512: at =
"INFOJOBS2.LLANSA_PUSH_DIARIO_ARCHIVOS", line 253 ORA-29540: class oracle/plsql/net/TCPConnection does = not exist
 ORA-06512: at line 2

I did launch the scripts initjvm.sql, initplsj.sql = and made a javaload of
 plsql.jar file...

any suggestions??

<P><FONT SIZE=3D2>&nbsp;---------------------------------------</FONT>

Javier Morales  - = javier_at_infojobs.net

<BR><FONT SIZE=3D2>&nbsp;Administraci=F3n Bases de Datos Oracle - =
InfoJobs.net</FONT>
<BR><FONT SIZE=3D2>&nbsp;Tel. +34&nbsp; 902 10 60 90&nbsp; Ext. =
2067</FONT>
<BR><FONT SIZE=3D2>&nbsp;Fax. +34 (93) 580 56 60</FONT>
<BR><FONT SIZE=3D2>&nbsp;</FONT>
</P>
<BR>
<BR>
<BR>

-----Mensaje original----- De: Raj Gopalan [<A = HREF=3D"mailto:raj.gopalan_at_netdecisions.co.uk">mailto:raj.gopalan_at_netdec= isions.co.uk</A>]
 Enviado el: martes 21 de noviembre de 2000 = 18:46

<BR><FONT SIZE=3D2>Para: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Asunto: DBMS_JOB</FONT>
</P>
<BR>

Hi all

<P><FONT SIZE=3D2>I need to schedule a procedure using dbms_job. =
</FONT>
</P>

I created it using the following script.

<P><FONT SIZE=3D2>declare</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; jobno&nbsp; number;</FONT>
<BR><FONT SIZE=3D2>begin</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; =

dbms_job.submit(jobno,'SP_MANUAL_REPLICATION;', = sysdate,'sysdate+1');

<BR><FONT SIZE=3D2>&nbsp;&nbsp; commit;</FONT>
<BR><FONT SIZE=3D2>end;</FONT>
</P>
<BR>

For some reason it not running at all.

Any thoughts?

TIA

<P><FONT SIZE=3D2>Raj</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Raj Gopalan</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: raj.gopalan_at_netdecisions.co.uk</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 To REMOVE yourself from this mailing list, send an = E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in
 the message BODY, include a line containing: UNSUB = ORACLE-L
 (or the name of mailing list you want to be removed = from).  You may
 also send the HELP command for other information = (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Javier Morales</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Javier_at_infojobs.net</FONT>
</P>

SIZE=3D2>---------------------------------------------------------------=