missing jaba libraries...

From: Javier Morales <Javier_at_infojobs.net>
Date: Tue, 21 Nov 2000 19:19:32 +0100
Message-Id: <10687.122644@fatcity.com>

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 Received on Tue Nov 21 2000 - 12:19:32 CST