Error ORA-917 Obtained With SQL*Loader When Using Function TO_DSINTERVAL (Doc ID 460422.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Records may be rejected due to ORA-917 and/or ORA-907, if a SQL string using the function TO_DSINTERVAL is specified in control file:

...
DUR POSITION(114:123) CHAR "DATAW.TOSECS(:DUR)" 
...

From function DATAW.TOSECS

...
ret := TO_DSINTERVAL (TRUNC (hhh/24, 0)||' '||MOD (hhh, 24)||mmss||'0') ;
RETURN ret;
...

Note: the problem will occur only in 10g database TO_DSINTERVAL is used.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms