Welcome Guest, Not a member yet? Register   Sign In
mySQL Stored Procedure "does not exist"
#1

CI v 3.1.10

I am trying to call a Stored Procedure without much success. I am getting an error message 

I have no problem calling the procedure from the mysql console in PHPStorm.

My code and the error

$stmt = "CALL spinup()";
$res = $db->query($stmt);
print_r( $db->errorInfo()); 
// Array ( [0] => 42000 [1] => 1305 [2] => PROCEDURE archives.spinup does not exist )

The procedure is created like so....

DELIMITER ;
DROP PROCEDURE IF EXISTS archives.spinup;
DELIMITER //

CREATE
    definer = admin@`%` PROCEDURE `archives`.`spinup`()
BEGIN


-- creating tables here....

SELECT "DONE";
END//
DELIMITER


I have searched high and low and can find no answer as to why the procedure is not being "found" since it absolute does exist.
Reply


Messages In This Thread
mySQL Stored Procedure "does not exist" - by alQemist - 11-26-2020, 03:55 AM



Theme © iAndrew 2016 - Forum software by © MyBB