When using the DbAdapter with an IBM DB2 database you encounter: java.sql.SQLException: [SQL0104] Token XXXXX was not valid. Valid tokens: DECLARE.
Last updated on OCTOBER 05, 2011
Applies to:Oracle SOA Platform - Version: 126.96.36.199.0
Information in this document applies to any platform.
DB2 database, for example:
CREATE PROCEDURE test8( IN new_value varchar(40))
SET value = new_value
WHERE id = 3;
You are able to call the procedure successfully from a DB2 SQL client. However, at run-time when a deployed composite invokes the same procedure via the DBAdapter, the composite invocation fails with the following fault:
Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'proc' failed due to: Stored procedure invocation error.
Error while trying to prepare and execute the MY_USER.TEST8 API.
An error occurred while preparing and executing the MY_USER.TEST8. Cause: java.sql.SQLException: [SQL0104] Token MY_USER was not valid. Valid tokens: DECLARE.
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms