Home > IT Answers > Development > Catching blocks using a stored procedure in S...
SQL Server Ask the Experts
2535 pts.
Q:
Catching blocks using a stored procedure in SQL
SQL, Stored Procedures
I have a stored procedure in SQL that I use to catch blocks. This stored procedure is executed by a stored procedure higher up. How do I relay the error info, if there is error info, to the parent? Do I need to use a return code or is the error info just passed back, no matter what?
ASKED: Aug 5 2008  3:16 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
Mrdenny
50690 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
If you catch the error in a lower procedure you'll need to return the error code back up to the parent procedure. Within the parent you'll need to get the return value and do something based on it's value.
Last Answered: Aug 6 2008  3:01 AM GMT by Mrdenny   50690 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   50690 pts.  |   Aug 6 2008  3:01AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.