Db Adapter Error - Invalid object name "DUAL"
(Doc ID 1344627.1)
Last updated on MAY 12, 2023
Applies to:
Oracle SOA Suite - Version 11.1.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
While trying to insert data into a table created on MS SQL Server Database, the BPEL process throws the following error:
JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertInHector.Tblhector].
Caused by java.sql.SQLSyntaxErrorException: [OWLS][SQLServer JDBC Driver][SQLServer]Invalid object name 'DUAL'
insert failed. Descriptor name: [InsertInHector.Tblhector].
Caused by java.sql.SQLSyntaxErrorException: [OWLS][SQLServer JDBC Driver][SQLServer]Invalid object name 'DUAL'
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 |