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 :
Código SQL
[-]
FUNCTION database.GetNameSecretary does not exist
esta es la consulta
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
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
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetSpokeWithSecretary`(
IN `xstrIDContact` varchar(250)
)
BEGIN
SELECT datDateSpokeWith FROM tblSecretary
WHERE IDContact=xstrIDContact ORDER BY datDateSpokeWith desc;
END