Error ORA-917 Obtained With SQL*Loader When Using Function TO_DSINTERVAL
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1
Information in this document applies to any platform.
DUR POSITION(114:123) CHAR "DATAW.TOSECS(:DUR)"
From function DATAW.TOSECS
ret := TO_DSINTERVAL (TRUNC (hhh/24, 0)||' '||MOD (hhh, 24)||mmss||'0') ;
Note: the problem will occur only in 10g database TO_DSINTERVAL is used.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms