This discussion is archived
0 Replies Latest reply: Aug 20, 2012 5:57 AM by 690951 RSS

Job done succeeded but with no effect.

690951 Newbie
Currently Being Moderated
(11g)
Annoing issue is happening with my procedure. It works perfectly when i execute it manualy via sqlplus(lasts over 5 sec), but i made a scheduled job with this procedure, and now it lasts less than one second, and completes SUCCEEDED... with no data changed.

Here is a statement:

BEGIN
generate_gid(i_prefix => '0009', i_note => 'gen_gid', i_do_commit => c.yes);
END;

i am a newbie in oracle so can you please tell me if any addition information is required to solve this guess.

Name      GENERATE_GID_IVC_MAIN
Schema     ROSTOV_IVC_MAIN
Enabled     TRUE
Description     None
Logging Level     Log everything (FULL)
Job Class     DEFAULT_JOB_CLASS
Auto Drop     FALSE
Restartable     FALSE
Repeat     By Hours
Interval (Hours)     1
Available to Start     11-Jan-2010 00:00:00 GMT+04:00
Raise Events     None
Maximum Run Duration (minutes)     None
Priority     Medium
Schedule Limit (minutes)     None
Maximum Runs     None
Maximum Failures     None
Job Weight     1
Instance Stickiness TRUE

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points