pls help how to fix this ERROR 1064 (42000):

[xtops]

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')

 

 

DELIMITER //
CREATE PROCEDURE ValidateData(IN in_IpPhno VARCHAR(30),  in_loc VARCHAR(30),    OUT out_status INT) 
MODIFIES SQL DATA
BEGIN     
           IF (!EXISTS(SELECT IpPhone, location  FROM IpPhoneList  
                             WHERE IpPhoneNo = in_IpPhno OR location = in_loc;)) THEN     
                  set out_status = '1';
                  INSERT INTO IpPhonelist (IpPhoneNo, location)
                           VALUES (in_IpPhno, in_loc);
            ELSE  
                  set out_status = '0';
            END IF;
END//

[Philip]

IF (!EXISTS(SELECT IpPhone, location  FROM IpPhoneList  
                             WHERE IpPhoneNo = in_IpPhno OR location = in_loc;))

the ; is not needed.

[xtops]

ok i fixed it  but new error found when i call my stored procedure

 

>CALL  ValidateData('1111','test');

 

ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE IpPhoneDir.ValidateData; expected 3, got 2

 

[xtops]

 

ok i fixed it  but new error found when i call my stored procedure

 

>CALL  ValidateData('1111','test');

 

ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE IpPhoneDir.ValidateData; expected 3, got 2

 

plz help how to wrong with this code?

 

[xtops]

 

ok i fixed it  but new error found when i call my stored procedure

 

>CALL  ValidateData('1111','test');

 

ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE IpPhoneDir.ValidateData; expected 3, got 2

 

 

pls!! help whats wrong with this code

[fenway]

The error tells you exactly what's wrong... you're missing a parameter.