MySQL Forums
Forum List  »  General

Re: My SQL Query to find the status of the SKU items manufactured
Posted by: Peter Brawley
Date: April 26, 2022 06:49AM

The requirement is clearly laid out, but this sort of detailed business logic looks rather more like a contract job than a help question on a community forum.

How it's approached depends somewhat on what coding standards and conventions are in place in your organisation, but I would think the best approach would be to write a stored procedure---or a small cascade of them---so that database errors and business logic exceptions can be handled with a combination of GET DIAGNOSTICS, SIGNAL and DECLARE EXIT HANDLER FOR SQLEXCEPTION.

Options: ReplyQuote


Subject
Written By
Posted
Re: My SQL Query to find the status of the SKU items manufactured
April 26, 2022 06:49AM


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.