Message-Id: <10687.122655@fatcity.com> From: Alex Hillman Date: Tue, 21 Nov 2000 15:02:00 -0500 Subject: RE: missing jaba libraries... 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@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@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@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@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@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@infojobs.net 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@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). ------_=_NextPart_001_01C053F5.E8D99830 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: missing jaba libraries...

You should load java in your database.

Alex Hillman

-----Original Message-----
From: Javier Morales [mailto:Javier@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@infojobs.net
 Administraci=F3n Bases de Datos Oracle - = InfoJobs.net
 Tel. +34  902 10 60 90  Ext. = 2067
 Fax. +34 (93) 580 56 60
 






-----Mensaje original-----
De: Raj Gopalan [mailto:raj.gopalan@netdec= isions.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. =

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.

Any thoughts?

TIA

Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Gopalan
  INET: raj.gopalan@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@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: http://www.orafaq.com
--
Author: Javier Morales
  INET: Javier@infojobs.net

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@fatcity.com (note EXACT spelling of = 'ListGuru') and in
the message BODY, include a line containing: UNSUB = ORACLE-L