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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.