Exec MSSQL stored procedure in datalist

 
1
0
-1

Hi Guy's hope you can help.

I am using JDBC Datalist Binder (using default datasource).

I need to call a stored proc with a parameter (i.e Exec 'stored proc name' 'parameter')

I'm getting FAILED TO RETRIEVE COLUMN LIST' exception.

Thanks for the help,

Cheers,

Ernest.

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi

      Good news! After months of intensive development, we're proud to announce the beta for Joget Workflow Version 6 is now available for download at http://www.joget.org/joget-workflow-v6/#next

      Read what's new in Joget workflow Version 6 at http://www.joget.org/joget-workflow-v6/

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi, I think the JDBC Datalist Binder only supports SQL SELECT statements. If you need something more you may need to develop a custom Datalist Binder Plugin.

          CommentAdd your comment...