intermedia text and dbms_job problem
OK, I know I must be doing something wrong, would somebody please point out what it is? I would like to set up a job to sync an intermedia text index. Here is my job: SQL select what from all_jobs where job = 2; WHAT - ctx_ddl.sync_index ( 'ctx_xml_text' ); I can execute the procedute from the command line like so: SQL execute ctx_ddl.sync_index ( 'ctx_xml_text' ); PL/SQL procedure successfully completed. But the job itself fails: SQL execute dbms_job.run ( 2 ); BEGIN dbms_job.run ( 2 ); END; * ERROR at line 1: ORA-12011: execution of 1 jobs failed ORA-06512: at SYS.DBMS_IJOB, line 405 ORA-06512: at SYS.DBMS_JOB, line 267 ORA-06512: at line 1 in my init.ora I have: job_queue_processes = 4 job_queue_interval = 60 I am in the ctxapp role, and ctxsys has granted me execute on ctx_ddl. The only other job works just fine. OS=Solaris, Version=8.1.7 What the heck is going on? Thanks in advance, 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Tantzen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 saiBill Tantzen [EMAIL PROTECTED] wrote: OK, I know I must be doing something wrong, would somebody please pointout what it is? I would like to set up a job to sync an intermedia textindex. Here is my job:SQL select what from all_jobs where job = 2;WHAT-ctx_ddl.sync_index ( 'ctx_xml_text' );I can execute the procedute from the command line like so:SQL execute ctx_ddl.sync_index ( 'ctx_xml_text' );PL/SQL procedure successfully completed.But the job itself fails:SQL execute dbms_job.run ( 2 );BEGIN dbms_job.run ( 2 ); END;*ERROR at line 1:ORA-12011: execution of 1 jobs failedORA-06512: at "SYS.DBMS_IJOB", line 405ORA-06512: at "SYS.DBMS_JOB", line 267ORA-06512: at line 1in my init.ora I have:job_queue_processes = 4job_queue_interval = 60! I am in the ctxapp role, and ctxsys has granted me execute on ctx_ddl.The only other job works just fine.OS=Solaris, Version=8.1.7What the heck is going on?Thanks in advance,BillBill Tantzen University of Minnesota Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125 (cell)I guess the man's a genius, but whata dirty mind he has, hasn't he? -- Nora Joyce-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bill TantzenINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message! BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: intermedia text and dbms_job problem
Title: Message Sai, Thank you so very much! It worked perfectly!!! Bill Bill TantzenUniversity of Minnesota Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125 (cell)I guess the man's a genius, but whata dirty mind he has, hasn't he? -- Nora Joyce -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sai SelvaganesanSent: Wednesday, October 08, 2003 3:19 PMTo: Multiple recipients of list ORACLE-LSubject: 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
FW: DBMS_JOB problem
OK OK so I missed the semicolon after the 'statspack.snap' command . . . sorry. problem fixed - back to normal state. -bill -Original Message- From: Magaliff, Bill Sent: Friday, December 13, 2002 11:55 AM To: Oracle-L (E-mail) Subject: DBMS_JOB problem I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on Metalink, I've try to run the following: SQL variable x number; SQL begin 2 dbms_job.submit(:x,'statspack.snap',sysdate,'sysdate + 1/24'); 3 end; 4 / begin * ERROR at line 1: ORA-06550: line 1, column 108: PLS-00103: Encountered the symbol END when expecting one of the following: := . ( @ % ; The symbol ; was substituted for END to continue. ORA-06512: at SYS.DBMS_JOB, line 79 ORA-06512: at SYS.DBMS_JOB, line 131 ORA-06512: at line 2 Any ideas on this error? No helpful info on Metalink. Checked the status of the package, too: 1* select object_type, status from all_objects where object_name = 'DBMS_JOB' SQL / OBJECT_TYPESTATUS -- --- PACKAGEVALID SYNONYMVALID Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
DBMS_JOB problem
I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on Metalink, I've try to run the following: SQL variable x number; SQL begin 2 dbms_job.submit(:x,'statspack.snap',sysdate,'sysdate + 1/24'); 3 end; 4 / begin * ERROR at line 1: ORA-06550: line 1, column 108: PLS-00103: Encountered the symbol END when expecting one of the following: := . ( @ % ; The symbol ; was substituted for END to continue. ORA-06512: at SYS.DBMS_JOB, line 79 ORA-06512: at SYS.DBMS_JOB, line 131 ORA-06512: at line 2 Any ideas on this error? No helpful info on Metalink. Checked the status of the package, too: 1* select object_type, status from all_objects where object_name = 'DBMS_JOB' SQL / OBJECT_TYPESTATUS -- --- PACKAGEVALID SYNONYMVALID Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: DBMS_JOB problem
Bill, Try putting a ';' after snap that may fix it. SQL variable x number; SQL begin 2 dbms_job.submit(:x,'statspack.snap;',sysdate,'sysdate + 1/24'); 3 end; 4 / I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on Metalink, I've try to run the following: SQL variable x number; SQL begin 2 dbms_job.submit(:x,'statspack.snap',sysdate,'sysdate + 1/24'); 3 end; 4 / begin * ERROR at line 1: ORA-06550: line 1, column 108: PLS-00103: Encountered the symbol "END" when expecting one of the following: := . ( @ % ; The symbol ";" was substituted for "END" to continue. ORA-06512: at "SYS.DBMS_JOB", line 79 ORA-06512: at "SYS.DBMS_JOB", line 131 ORA-06512: at line 2 Any ideas on this error? No helpful info on Metalink. Checked the status of the package, too: 1* select object_type, status from all_objects where object_name = 'DBMS_JOB' SQL / OBJECT_TYPE STATUS -- --- PACKAGE VALID SYNONYM VALID Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
DBMS_JOB problem
I have a job: DECLARE myjob NUMBER; BEGIN dbms_job.submit(myjob, 'FWHI.Fwh_Gen_Txt.GENALLFILES ( ''||@||'', 1 );', SYSDATE, 'sysdate+10*60/24*60*60'); commit; END ; PL/SQL procedure successfully completed the job_queue_processes 4 job_queue_interval 60 If I force the execution is generating the right number of txt files, 74, if I wait to be triggered it generates just 8 files and it stops. Why? Ciprian Maftei -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).