 |
 |
Archives of the TeradataForum
Message Posted: Fri, 26 Nov 2010 @ 19:05:46 GMT
| Subj: | | Re: Pros and Cons of Stored Procedures |
| |
| From: | | Geoffrey Rommel |
| | But the reason I choose to stay away from them is ending up with 5000 line stored procedures that aborted and not being able to figure out
what went wrong. | |
Cesar makes a good point. I recommend creating a log table and writing messages to it now and then from the stored procedure so that you have a
record of what happened. Also, if your procedure is 5000 lines, it's time to separate it into two or more smaller procedures.
| |
