Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Error IN/OUT Paraamter in DBaaS adapter — Cloud Customer Connect
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
edited Jul 10, 2020 10:49AM in Integration 2 comments



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=""&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.


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