Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Urgent! on dbms_job

Urgent! on dbms_job

From: Henk Boen <henk.boen_at_terbit.nl>
Date: Mon, 18 Sep 2000 00:14:56 +0200
Message-ID: <39C54260.2BE91401@terbit.nl>

Hello all,
The configuration: oracle 8.1.5 on NT4 or NT2000 the following parameters are set in init.ora job_queue_interval = 20 (20 seconds?)
job_queue_processes = 1

The problem is that I am not able to run dbms_job.submit Even with a simple tes tit does not work: I created the following table:
testh (name varchar2(20))
insert into testh values('xxxx');

and procedure:
create or replace procedure putname(p_name in varchar2) as
begin
  update testh

      set name=p_name;
end;
/

in sqlplus
var x number;

(as a dba !)

sql>exec dbms_job.submit(:x,'putname(''helpppppp'') ; commit ; ', sysdate+1/1440);
plssql succesfully completed

Just wait and wait and wait....
select job from user_jobs just gave the same jobnr. as the value of x
(print x)

select * from testh just give 'xxxx'....

Only when i do dbms.run(:x) it will update the table.

I have looked in bdump but no trace file of snp0.trc of something alike.

I have also look in the alertlog and also no indication

What did I do wrong?????? Do I missed some points here?

Glad to hear if somebody else has encounters the same problem or has a solution for me.

henk

PS: This my second post for the same problem Received on Sun Sep 17 2000 - 17:14:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US