Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2004 @ 14:43:23 GMT
| Subj: || || Re: Stored Procedures - Pros & Cons |
| From: || || Harold D Kleven |
We have one application that is heavily vested in SPs. They took the approach - and we didn't stop it - of coding specific application logic in
the SPs and a lot of SQL in each. The SPs are not, generally, reusable units. I would recommend NOT taking that approach because I personally
favor simple, reusable code units and, more importantly, there are no debugging aids for SPs. And TSET can't handle a SP.