I have a stored proc that I want to call from my AWS lambda. The value of the parameter will change with each invocation which is why it cannot be hardcoded (to state the obvious).

From the boto3 documentation I believe that this is the way to do it:

```
response = rs_client.execute_statement(
            ClusterIdentifier='my_cluster_name',
            Database='my_db_name',
            DbUser='my_user'',
            Sql='call my_schema.this_is_my_proc()',
            Parameters=[{'name': 'in_param', 'value': 'this is the parameter'}],
            StatementName='Test of SP call'
        )

```

but I get this error:

```
An error occurred (ValidationException) when calling the ExecuteStatement operation: Parameters list contains unused parameters. Unused parameters: [in_param]

```

I can call it with a hardcoded parameter which works but is of course pointless (but proves that the call to the proc works):

```
Sql="call my_schema.this_is_my_proc('and this is the parameter')"

```

For completeness my stored proc heading looks like this:

```
create or replace procedure my_schema.this_is_my_proc(in_param varchar)
as $$
declare
...

```

Is it possible to call a Redshift SP with one or more parameters from a lambda using boto3?

Edit - the Parameter argument would look something like this:

```
Parameter=[{'name': 'in_param', 'value': a_variable}]

```

Thanks