I'm trying to update with a stored procedure but the procedure doesn't work these are some pictures
not even this stored procedure works i don't know why
Discussion posts and replies are publicly visible
MariaDB does not allow for update statements with stored procedures docs.appian.com/.../Mariadb_Upgrade_Guide.html
Danny, what about Delete ? is it allowed ?
No, if you open the link it will show a table of unsupported statements
Well in that case there are stored procedures which was created a long time ago and they are using delete and are working, any idea ?
Appian converted its database from MySQL to MariaDB, that's why they used to work and now they don't. Sadly, you'll need to think of other ways to meet your use case
That is okay, but what I am saying is that today we have Stored Procedure with Delete statement that are still working, and would like to find out why.
© 2022 Appian. All rights reserved.