MySQL Forums
Forum List  »  General

Stored procedure is created but I get "Error Code: 1305. FUNCTION DB.extract_items does not exist" when using it
Posted by: Luciano Almeida
Date: January 21, 2023 11:41AM

Hello all! Anyone seen this error before?

I created the following procedure on the database CWCust_DB:

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

And I'm trying to use the function on this select:

SELECT extract_items(Items) FROM HSE.ComplianceFlag

But, I'm getting this response:

Error Code: 1305. FUNCTION CWCust_DB.extract_items does not exist

I can't figure out what's wrong... Someone help, please?

I am using the same database where the procedure was created.

Options: ReplyQuote


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


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.