mySQL Stored Procedure "does not exist"

Thanks for all the replies - problem was discovered by my colleague who is the CI admin. Turns out the PDO connection was pointing to a different instance of our RDS on AWS. Once I switch the target RDS it worked like a charm !