ORA-30086 Error Code Description:



 Error ORA-30086
 Description interval year-month result not allowed for datetime subtraction
 Cause An attempt was made to specify interval year to month as the result of datetime subtraction.
 Action This is not allowed currently due to unclear specification in SQL Standards for this interval type. Change the interval type to interval day to second and resubmit statement.


0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
OraError.net © 2007 • Privacy PolicyTerms Of Use