LLamar proc almacenado desde una conuslta mysql

[unseo1989]

HOlas tengo 2 procedimiento almacenados y una consulta ..desde esa consulta tengo ke llamar estos procediemntos almacenado y me sale error gracias ..por sus respuestas

me sale este error :

FUNCTION database.GetNameSecretary does not exist

esta es la consulta

Código MySQL:

SELECT ifnull(IDContact,'') as IDContact, 
ifnull(txtActualContact,'') as 'Actual Contact', 
ifnull(IDTitle,'') as idtitle , 
ifnull(getCompleteName(txtLastName,txtFirstName),'') as 'Contact Name',
ifnull(date(datDateSpokeWith),'') as 'Spoke Exec',
ifnull(GetNameSecretary(IDContact),'') as ' Sec Name',
ifnull(GetSpokeWithSecretary(IDContact),'') as 'Spoke Sec', 
date(datDateNoLongerEmployedbyCompany) as 'NoLonger',
IDInterestLevel FROM tblcontact
 

este es el proc alamacenado 1

Código MySQL:

DELIMITER $$
 
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetNameSecretary`(
  IN `xstrIDContact` varchar(250)
)
BEGIN
    DECLARE xFirstName VARCHAR(50);
  DECLARE xCount INTEGER;
  SELECT xCount=COUNT(*) FROM tblSecretary WHERE IDContact=xstrIDContact GROUP BY IDContact;
  IF xCount>1 then
  
    SELECT xFirstName = GetCompleteName(txtLastName,txtFirstName) 
        FROM tblSecretary WHERE intPriority=1 AND IDContact=xstrIDContact;
  end if;
  IF xCount=1 then
  
    SELECT xFirstName = GetCompleteName(txtLastName,txtFirstName) 
        FROM tblSecretary WHERE IDContact=xstrIDContact;
  END if;
    
END
 

y este es el segundo

Código MySQL:

DELIMITER $$
 
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetSpokeWithSecretary`(
  IN `xstrIDContact` varchar(250)
)
BEGIN
    
  SELECT datDateSpokeWith FROM tblSecretary  
    WHERE IDContact=xstrIDContact ORDER BY datDateSpokeWith desc;
    
END