1 Reply Latest reply: May 17, 2013 4:47 AM by Mkirtley-Oracle RSS

    Cronology error

      i am running a job through CRONOLOGY tool which is job scheduler tool. The job which i m running is generally run once in a month. The issue i am facing is, whenever the job is run for the very first time in a month, it shows one ORA error but it goes through fine when the job is rerun. The error is
      ORA-01862: the numeric value does not match the length of the format item.

      Please help me understand why does the error appear in the first run when it doesn't apper when the job is rerun.?
        • 1. Re: Cronology error
          This forum is specifically for problem using the Oracle SQL*Developer product.
          It would be better to ask this question the SQL and PL/SQL forum here -


          but you will need to provide the code being run from the job and try to identify the code that gives the error.