RE: intermedia text and dbms_job problem

[Bill Tantzen]

Title: Message

Sai,

 

Thank you so very much!  It worked perfectly!!!

 

Bill

Bill Tantzen
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)
________________________________________________________________
I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sai Selvaganesan
Sent: Wednesday, October 08, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: intermedia text and dbms_job problem

bill

this is a bug..infact it was happening in 8i and oracle said they will try to fix in 9i.

u have to call the procedure in the ur job and embed the sync index in ur procedure.

here is a snippet.u can try this way.

 create or replace procedure i_doc_sync

  is

  begin

    ctx_ddl.sync_index( idx_name => 'prb_title');

  end;

 

declare

  v_job number;

  begin

  dbms_job.submit( job=>v_job, what=>'i_doc_sync;', next_date=>sysdate, interval=>'sysdate+1/24');

  end;

 

that should work

sai