Home » SQL & PL/SQL » SQL & PL/SQL » Getting this issue (oracle 10g)
Getting this issue [message #413502] Thu, 16 July 2009 02:16 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
BEGIN
DBMS_SCHEDULER.drop_job 
(
 job_name    => 'EMREncounterData_Sync',
 force                  =>  FALSE
 
);

dbms_scheduler.create_job(
job_name=>'EMREncounterData_Sync',
job_type=>'PLSQL_BLOCK',
job_action=>'BEGIN 
EXECUTE IMMEDIATE(''alter index HPI_DATA_Index rebuild online parameters(''''sync'''')''); 
EXECUTE IMMEDIATE(''alter index ROS_DATA_Index rebuild online parameters(''''sync'''')'');  
EXECUTE IMMEDIATE(''alter index PHYSICAL_EXAM_DATA_Index rebuild online parameters(''''sync'''')'');  
EXECUTE IMMEDIATE(''alter index DIAGNOSIS_DATA_Index rebuild online parameters(''''sync'''')'');  
EXECUTE IMMEDIATE(''alter index PLAN_DATA_Index rebuild online parameters(''''sync'''')'');
EXECUTE IMMEDIATE(''alter index ICD9_DATA_Index rebuild online parameters(''''sync'''')''); 
commit; END;',
start_date=>TRUNC(SYSDATE+1),
repeat_interval=>'TRUNC(SYSDATE+1)',
end_date=>NULL,
enabled=>TRUE,
comments=>'Full text indexing');
END;
/
COMMIT
/




Error report:
ORA-27475: "EZEMRXMODERNCLI.EMRENCOUNTERDATA_SYNC" must be a job
ORA-06512: at "SYS.DBMS_ISCHED", line 178
ORA-06512: at "SYS.DBMS_SCHEDULER", line 544
ORA-06512: at line 2
27475. 00000 - "\"%s.%s\" must be a %s"
*Cause: An object of the wrong type was specified. For example, a table
could have been passed to the drop_job() procedure.
*Action: Reissue a different command applicable to this object type or
reissue the same command using an object of the valid type.

what is this actually and how to solve this kind of errors
Re: Getting this issue [message #413503 is a reply to message #413502] Thu, 16 July 2009 02:38 Go to previous message
bonker
Messages: 402
Registered: July 2005
Senior Member
If you have coded this then you must know how to debug as well?

The error is quite obvious "ORA-27475: "EZEMRXMODERNCLI.EMRENCOUNTERDATA_SYNC" must be a job"

I am guessing that EMRENCOUNTERDATA_SYNC job does not exist at the time you try to drop it and therefore its failing with error ORA-27475

[Updated] last sentence was incomplete earlier.

[Updated on: Thu, 16 July 2009 02:46]

Report message to a moderator

Previous Topic: how to use Case statement in where clause (with respect to Input Params &) (merged)
Next Topic: pl/sql
Goto Forum:
  


Current Time: Thu Nov 14 04:19:56 CST 2024