Cannot read undefined properties error in stored procedure MySQL

Viewed 21

I'm trying to call a stored procedure, but it gave me this error for some reason: enter image description here

Here's the code for it:

USE test;

CREATE PROCEDURE test8()
BEGIN
    SELECT * FROM test.order_id;
END;

CALL test8();

I think the problem is in the querry within the procedure, as when I call a random name that doesn't exist as a procedure it will throw a specific error relating to it.

Thanks.

0 Answers
Related