I have stored procedures which call other stored procedures for the purpose of reduced points of maintenance. The issue is all the sub stored procedures in the main one also return resultsets. I want to ignore these in my main SP and retrun a single resultselt at the end, which is an error code.
Is it possible to clear the pending resultsets at the end of a storedprocedure? I found how to access the OUTPUT buffer, however there doesn't seem to be a way of clearing it. Has anyone tried this, or got any ideas for how to overcome this?