MySQL Forums
Forum List  »  General

Re: Stored procedure is created but I get "Error Code: 1305. FUNCTION DB.extract_items does not exist" when using it
Posted by: Benoit St-Jean
Date: January 21, 2023 01:48PM

You need to create a FUNCTION, not a PROCEDURE !

DELIMITER //
CREATE FUNCTION extract_items()
BEGIN
-- DO STUFF
END //
DELIMITER ;

You should read about the difference between a FUNCTION and a PROCEDURE!

Hope this helps!

Options: ReplyQuote


Subject
Written By
Posted
Re: Stored procedure is created but I get "Error Code: 1305. FUNCTION DB.extract_items does not exist" when using it
January 21, 2023 01:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.