Unable to call snowflake stored procedure using Script activity by passing parameters

I am trying to call 2 snowflake stored procedures using script activity.

Stored procedures are as follows:

DUMMY1();

DUMMY2(Message VARCHAR);

I am able to call the one without arguments, but not able to call the one with parameters.

I get the following error :

ERROR [07002] [Microsoft][ODBC] (10690) Expected descriptor record does not exist during query execution.

Below are the ways I tried :
1. CALL DUMMY('Welcome')
2. CALL DUMMY(?) - created one script parameter