You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error IN/OUT Paraamter in DBaaS adapter

Received Response
13
Views
2
Comments
edited Jul 10, 2020 10:49AM in Integration 2 comments

Content

Hey,

I'm using a dbaas adapter to perfom a query on a database. I will get this error currently:

Error message is - DBReadInteractionSpec Execute Failed Exception.
Query name: [getOrgIdSelect], Descriptor name: [getOrgId.Integrationkeymap].
Caused by java.sql.SQLException: Missing IN or OUT parameter at index:: 1.
See root exception for the specific exception. This exception is considered retriable, likely due to a communication failure.
Missing IN or OUT parameter at index:: 1Fault Details :
<err:serviceInvocationError xmlns:err="http://xmlns.oracle.com/cloud/generic/service/fault"&gt;
<err:type>DBReadInteractionSpec Execute Failed Exception</err:type>
<err:title>Query name: [getOrgIdSelect], Descriptor name: [getOrgId.Integrationkeymap].</err:title>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!