Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    12

    Unanswered: ORA-01873: the leading precision of the interval is too small

    Hi All,
    I am encountering this error in a pl/sql procedure.

    The procedure is used to update some business related variable values. The procedure is calcualting the total time taken for this update.
    At one place the curent timestamp is stored in a variable and after the update the current timestamp is stored in another variable. Both the variables are of type 'systimestamp'. The result of this expression is stored in a variable whose type is given as:
    ‘INTERVAL DAY (0) TO SECOND (6)’.

    The error is occurring randomly. Can anyone help me in this regards?

    Thanks in advance,
    Kaushik
    kaushik mitra

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    This is what Oracle says:
    ORA-01873: the leading precision of the interval is too small

    Cause: The leading precision of the interval is too small to store the specified interval.

    Action: Increase the leading precision of the interval or specify an interval with a smaller leading precision.
    P.S. Is this "random occurrence" connected with the fact that DAY (0) isn't enough?

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •