Running a .sql file

[Rahul R M Desai]

Hi all,
 
I have some procedures and functions in a .sql file. What I need to do
is 
1. create the procedures and functions.
2. Execute them.
3. Drop the procedures and functions.
 
All this I have to do in a perl script.
I was trying to find a way to create the procedures in the file.
I tried :
eval {
    my $func = $dbh->prepare(  <mailto:'@C:\MyProject\file.sql'>
'@C:\MyProject\file.sql');
    $func->bind_param(":parameter1", $timestamp); 
    $func->execute;
    $dbh->commit;
};
which is not working :-)
 
Is there any way that I can achieve this.
 
TIA,
Rahul Desai