How to use variables (in insert string)

[Tim Vantag]

Hi.

How can I use variables in insert string When I execute procedure?

Perl Example:

my $name="John Doe";

my $sql='CALL insert_name($name)';
my $sth = $connection->prepare($sql);
$sth->execute;
$sth->finish;

Now when I run this perl-script, I get error:

Unknown column '$name' in 'field list' at..

How should I write $sql-string?