I'm using Oracle Database and .Net Core API for my project.
What is the best way / best practice of handling errors between Database and API?
What I'm thinking is, I'll return only custom error code (in case of validation errors) from my stored procedure and in API side I'll evaluate the error code and get the proper error message from either resource file / error XML file.
Is it the right way? Please help.