DELIMITER $$
CREATE PROCEDURE SP_Register_Role(
    IN _Role_Name VARCHAR(10),
    OUT _Status VARCHAR(30))
 BEGIN
    DECLARE CheckExists int;
    SET CheckExists = 0;
    SELECT COUNT(*) INTO CheckExists FROM Role_Master WHERE Role_Name = _Role_Name;
    IF CheckExists > 0 THEN
        SET _Status = 'Role Already Exists';
    ELSE
        INSERT INTO Role_Master(Role_Name) VALUES(_Role_Name);
        SET _Status =  'Role Created';
    END IF;
END$$

$dbh = PHP_DB_Connect();
		$Qry = $dbh->prepare("CALL SP_Register_Role(?,?)");
		$Qry->bindParam(1,$_POST["RoleName"],PDO::PARAM_STR,10);
		$Qry->bindParam(2,$SP_Return_Value,PDO::PARAM_STR|PDO::PARAM_INT_OUT,30);
		$Result = $Qry->execute();
		if(!$Result){
			  $arr = $Qry->errorInfo();
			  print_r($arr);
		}else{
			print $SP_Return_Value;
		}