RE: missing jaba libraries...

From: Javier Morales <Javier_at_infojobs.net>
Date: Wed, 22 Nov 2000 10:25:51 +0100
Message-Id: <10688.122704@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_01C05467.3AFD10A0
Content-Type: text/plain;

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

when I start the database there's the message "JServer Release = 8.1.6.0.0 -
Production"
=20
so, how should I load java in my database??

=20
=20
=20

Thanks,

 ---------------------------------------=20

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

-----Mensaje original-----
De: Alex Hillman [mailto:alex_hillman_at_physia.com] Enviado el: martes 21 de noviembre de 2000 21:08 Para: Multiple recipients of list ORACLE-L Asunto: RE: missing jaba libraries...

You should load java in your database.=20

Alex Hillman=20

-----Original Message-----=20
From: Javier Morales [ mailto:Javier_at_infojobs.net
<mailto:Javier_at_infojobs.net> ]=20

Sent: Tuesday, November 21, 2000 1:32 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: missing jaba libraries...=20

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

SVRMGR> execute infojobs2.llansa_push_diario_archivos;=20

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

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

any suggestions??=20

 ---------------------------------------=20

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

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

Hi all=20

I need to schedule a procedure using dbms_job.=20

I created it using the following script.=20

declare=20

jobno number;=20
begin=20

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

commit;=20
end;=20

For some reason it not running at all.=20

Any thoughts?=20

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

--=20
Author: Raj Gopalan=20
INET: raj.gopalan_at_netdecisions.co.uk=20

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

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

--=20
Author: Javier Morales=20
INET: Javier_at_infojobs.net=20

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

------_=_NextPart_001_01C05467.3AFD10A0
Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: missing jaba libraries...</TITLE>

<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV>when=20
I start the database there's the message "JServer Release 8.1.6.0.0 -=20 Production"</DIV>
<DIV><SPAN=20
class=3D897202709-22112000> </DIV>
<DIV>so,=20
how should I load java in my database??</DIV>
<DIV><SPAN=20
class=3D897202709-22112000> </DIV>
<DIV><SPAN=20
class=3D897202709-22112000> </DIV>
<DIV><SPAN=20
class=3D897202709-22112000> </DIV>
<DIV><SPAN=20
class=3D897202709-22112000>Thanks,</DIV>
<DIV>
<FONT face=3DVerdana=20

size=3D2>&nbsp;---------------------------------------</FONT> <BR><FONT =

face=3DVerdana size=3D2> Javier Morales  - = javier_at_infojobs.net=20
  Administraci=F3n Bases de Datos =
Oracle -=20
InfoJobs.net  Tel. = +34 =20
902 10 60 90 =20
Ext. 2067  Fax. +34 (93) = 580 56=20
60  =20
 </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Mensaje original----- De: Alex Hillman=20 [mailto:alex_hillman_at_physia.com] Enviado el: martes 21 de = noviembre=20
 de 2000 21:08 Para: Multiple recipients of list=20 ORACLE-L Asunto: RE: missing jaba =

libraries...<BR><BR></DIV></FONT>
  <P><FONT size=3D2>You should load java in your database.</FONT> </P>
  <P><FONT size=3D2>Alex Hillman</FONT> </P>
  <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =

size=3D2>From:=20
 Javier Morales [<A=20
 =
href=3D"mailto:Javier_at_infojobs.net">mailto:Javier_at_infojobs.net</A>]</FON= T>=20
 Sent: Tuesday, November 21, 2000 1:32 PM =
 <FONT=20

 size=3D2>To: Multiple recipients of list ORACLE-L <FONT=20 size=3D2>Subject: missing jaba libraries... I try to execute one procedure that uses  = UTL_FILE and=20
 UTL_SMPT and I get this error... =


 SVRMGR> execute=20 infojobs2.llansa_push_diario_archivos; ORA-29540:=20

  class oracle/plsql/net/TCPConnection does not exist</FONT> <BR><FONT=20
  size=3D2>ORA-06512: at "SYS.UTL_TCP", line 533</FONT> <BR><FONT=20
  size=3D2>ORA-06512: at "SYS.UTL_TCP", line 199</FONT> <BR><FONT=20
  size=3D2>ORA-06512: at "SYS.UTL_SMTP", line 99</FONT> <BR><FONT=20

size=3D2>ORA-06512: at "SYS.UTL_SMTP", line 121 <FONT=20 size=3D2>ORA-06512: at "INFOJOBS2.LLANSA_PUSH_DIARIO_ARCHIVOS", line = 253=20
 ORA-29540: class oracle/plsql/net/TCPConnection = does not=20
 exist ORA-06512: at line 2 I did launch the scripts initjvm.sql, initplsj.sql = and made a=20
 javaload of plsql.jar file... any suggestions?? <FONT =

size=3D2>&nbsp;---------------------------------------</FONT> <BR><FONT =

size=3D2> Javier Morales  - javier_at_infojobs.net =
 <FONT=20

 size=3D2> Administraci=F3n Bases de Datos Oracle - = InfoJobs.net=20
  Tel. +34  902 10 60 90  Ext. = 2067=20
  Fax. +34 (93) 580 56 60 <FONT=20 size=3D2>  -----Mensaje original----- De: Raj=20
 Gopalan [<A=20
 =
href=3D"mailto:raj.gopalan_at_netdecisions.co.uk">mailto:raj.gopalan_at_netdec= isions.co.uk</A>]=20
 Enviado el: martes 21 de noviembre de 2000 = 18:46=20
 Para: Multiple recipients of list ORACLE-L =
 <FONT=20

 size=3D2>Asunto: DBMS_JOB Hi all 
 I need to schedule a procedure using dbms_job. =


 I created it using the following script. =


 declare    = jobno =20
 number; begin   =20
 dbms_job.submit(jobno,'SP_MANUAL_REPLICATION;', = sysdate,'sysdate+1');=20
    commit; end;=20

  </P><BR>
  <P><FONT size=3D2>For some reason it not running at all. </FONT></P>
  <P><FONT size=3D2>Any thoughts?</FONT> </P>
  <P><FONT size=3D2>TIA</FONT> </P>
  <P><FONT size=3D2>Raj</FONT> <BR><FONT size=3D2>-- </FONT><BR><FONT =

size=3D2>Please=20
see the official ORACLE-L FAQ: <A href=3D"http://www.orafaq.com"=20 target=3D_blank>http://www.orafaq.com</A> <FONT =

size=3D2>--=20
  </FONT><BR><FONT size=3D2>Author: Raj Gopalan</FONT> <BR><FONT =
size=3D2>&nbsp;=20

INET: raj.gopalan_at_netdecisions.co.uk Fat City Network Services    -- = (858)=20
 538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>---------------------------------------------------------------=

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

size=3D2>--=20
  </FONT><BR><FONT size=3D2>Author: Javier Morales</FONT> <BR><FONT =
size=3D2>&nbsp;=20

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

size=3D2>---------------------------------------------------------------=