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 later
Information in this document applies to any platform.

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.

	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

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