Returning mysql procedure error

bharanidharanit · #1 (**permalink**) 08-22-11, 11:07

hi,
I hav a created a field with unique constraint, so if it got duplicated error must be returned from procedure. Wats wrong here?

PHP Code:


			
$dbconn = new DbConn;

        $dbc = $dbconn->Fn_CreateDbConn();

        $Qry = $dbc->prepare("CALL CMS_School_Insert(:SchoolID,:SchoolName)");    

        $Qry -> bindParam(":SchoolID",$SchoolID);

        $Qry -> bindParam(":SchoolName",$SchoolName);

                try

                {

            $Qry -> execute();

                 }catch(PDOException $e)

                  {

                      return "Error: ".$e->getMessage();

                  }

Here s my procedure

Code:

DELIMITER //

CREATE DEFINER=`root`@`localhost` PROCEDURE `CMS_School_Insert`(_SchoolID INT, _SchoolName VARCHAR(100))
BEGIN
    IF (SELECT COUNT(*) FROM CMT_School WHERE School_ID=_SchoolID) = 0 THEN
        INSERT INTO CMT_School (School_Name) VALUES (_SchoolName);
    ELSE
        UPDATE CMT_School SET School_Name=_SchoolName WHERE School_ID=_SchoolID;
    END IF;
END//

Internet Services

Web Development

Digital Marketing

Consumer Tech