# @parameter is the array with 3 parameters

  $csr = $db->prepare(q{
      BEGIN
          SQL_PROC_NAME(:1,:2,:3);
      END;
  });

  $csr->bind_param(":1", $parameter[0] );
  $csr->bind_param(":2", $parameter[1] );
  $csr->bind_param(":3", $parameter[2] );
 
  eval {
    $csr->execute;
  };