MySQL Forums
Forum List  »  General

Advanced Search
New Topic

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!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Stored procedure is created but I get "Error Code: 1305. FUNCTION DB.extract_items does not exist" when using it
Luciano Almeida
January 21, 2023 11:41AM
Re: Stored procedure is created but I get "Error Code: 1305. FUNCTION DB.extract_items does not exist" when using it
Benoit St-Jean
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.