Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
  • State Not Answered
  • Replies 2 replies
  • Subscribers 4 subscribers
  • Views 5446 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

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

vipins

#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

OriginalPostID-172817

OriginalPostID-172817

  Discussion posts and replies are publicly visible

Parents
  • 0
    Appian Employee
    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.
Reply
  • 0
    Appian Employee
    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.
Children
No Data
© 2026 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.