My Oracle Support Banner

ODI 12.1.3 Mapping Generates Inline View Name That Reads '_13' Which Causes "ORA-00911: invalid character" (Doc ID 1963996.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

A mapping in ODI 12.1.3 generates the code below: 

(xxxxxxx.xxxxxxx_xxxx (+) = INLINE_VIEW_8.xxxxxxx_xxxx_xxxx_xxxxx
)
) INLINE_VIEW_9 , xxxxxx.xxxxxxx xxxxxxx1
WHERE
(xxxxxxx1.xxxxxxx_xxxx (+) = INLINE_VIEW_9.xxxxxxx_xxxx_xxxx_xxxxx
)
) INLINE_VI_10 , xxxxxx.xxxxxxx xxxxxxxx
WHERE
(xxxxxxx1.xxxxxxx_xxxx (+) = INLINE_VI_10.xxxxxxx_xxxx_xxxx
)
) INLINE_11 , xxxxxx.xxxxxxx xxxxxxxx
WHERE
(xxxxxxx1.xxxxxxx_xxxx (+) = INLINE_11.xxxxxxx_xxxx_xxxx
)
) INL_12 , xxxxxx.xxxxxxx xxxxxxx1
WHERE
(xxxxxxx1.xxxxxxx_xxxx (+) = INL_12.xxxxxxx_xxxx_xxxx
)
) _13 , xxxxxx.xxxxxxx xxxxxxxx
WHERE
(xxxxxxx1.xxxxxxx_xxxx (+) = _13.xxxxxxx_xxxx_xxxx
)

Note the pattern of the inline view names:

INLINE_VIEW_9.
INLINE_VI_10
INLINE_11
INL_12
_13

The _13 causes the error below:

ODI-1228: Task Load xxx_xxxxxxxxxxx-IKM Oracle Insert- fails on the target
connection xx_xxxxxxxxxxxx.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.