Failure happened on 'Source' side. 'Type=MySql.Data.MySqlClient.MySqlException,Message=Parameter '@notify' must be defined. To use this as a variable, set 'Allow User Variables=true'

Question

Hello,

I have a stored proc in mariadb and unfortunately the Azure pipeline does not support odbc or mariadb linked services stored proce connection. Thus I found a workaround by using "Lookups". It works however the Look throughs an error if no value is returned. Therefore I used a OUT parameter to pass a dummy variable. Now the issue is that the variable in DF does throws an error. Kindly assist.

Code:

CALL removeduplicates(@notify);

Stored Proc:

CREATE OR REPLACE PROCEDURE removeduplicates ( OUT notify VARCHAR(20) )