IKM HINT SYNTAX IS NOT CORRECT
(Doc ID 3036773.1)
Last updated on JULY 31, 2024
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
During the insert connector executions , in IKM file hint syntax is not as expected.
Below is the sample :
v_create_stmt := 'insert into'; IF (threshold > 0) THEN v_create_stmt := v_create_stmt || ' /*+ NOAPPEND PARALLEL */ '; else
Below note can be seen in the oracle documentation :
https://docs.oracle.com/cd/B10500_01/server.920/a96533/hintsref.htm
The APPEND hint always follows the INSERT keyword, and the PARALLEL hint can follow the INSERT keyword.
Steps to Reproduce Problem
--------------------------
Execute the insert connector and verify insert new rows step which shows the query formation.
Changes
NA
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 |
Changes |
Cause |
Solution |
References |