"Ordinal binding and Name binding cannot be combined!" error when using Execute Stored Procedure

vipins over 8 years ago

#StoredProcedures

I am trying to use "Execute Stored Procedure" plugin. I have used the same code from attached file. I am getting some erros.
Can you please highlight what mistake I am doing?

I have attached the pic with proper scenarios.
If the problem is that CDT is not there, then I would like to tell that I created one more stored procedure for which CDT was there. but it was not giving me result that time too. The error was like :
"Interface Definition: Expression evaluation error at function 'type!{www.appian.com/.../2009}ColumnLayout' [line 21]: An array of components may only contain components. Received List of Variant at index 1."

Any Guesses on this?
Thanks for the Help

Discussion posts and replies are publicly visible

0 Shyam Bommakanti
Certified Lead Developer
over 8 years ago

Hope this helps you understand the issue better:
stackoverflow.com/.../what-is-ordinal-binding-and-named-binding-in-jdbc
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 James Carter
Appian Employee
over 8 years ago

The ESP function mixes ordinal and named parameters and you're using a database/JDBC driver that does not allow this. The plug-in needs to be updated to only use ordinal parameters (we have an internal ticket for this: CEX-3262).

There's no immediate plans to update the plug-in for this, although if you're working with Appian Professional Services it should be possible to update the plug-in through that engagement.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel