My Oracle Support Banner

Run SQL Query On MySQL Database To Load File (Doc ID 2499649.1)

Last updated on JULY 28, 2020

Applies to:

Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.

Goal

Why query run by the customer in OIC is not supported?

LOAD DATA INFILE "/u01/data/mysql/x/Test_position.txt" INTO TABLE test_position1(@var1) set name = TRIM(SUBSTR(@var1,1,10)),add1 =SUBSTR(@var1,11,10),addnum = SUBSTR(@var1,21,10),pin = SUBSTR(@var1,31,10),status ='YES';


Solution

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
Goal
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.