Mappings from Microsoft Excel to RDBMS Fields in an ODI 11g Integration Interface Generate "Too few parameters" Message
(Doc ID 424081.1)
Last updated on JANUARY 27, 2020
Applies to:Oracle Data Integrator - Version 3.2.03.01 to 126.96.36.199.99 [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.
When attempting to load a MySQL table with data from a Microsoft Excel spreadsheet, during the "Insert new lines" step of an Oracle Data Integrator (ODI) 11g Interface, the following message is signaled:
java.sql.SQLException: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source
The SELECT instruction for this step is as follows:
"ACTIVE" as STATUS,
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