Why should you use stored programs? Great question, here’s my
little insight into a situation that I heard about in a large
organization.
A very large organization is having a technology argument. In
someway, like politics, half-truth drives this type of
discussion. This company has hundreds of databases and they’re
about half SQL Server and Oracle. The argument (half-truth)
states that using T-SQL or PL/SQL yields “spaghetti” code!
It seems like an old argument from my perspective. After all,
I’ve been working with T-SQL and PL/SQL for a long time.
Spaghetti code exists in every language when unskilled
programmers solve problems but the point here is one of software
architecture, and an attempt to malign stored programming in
general. Let’s examine the merit of the argument against stored
programs.
First of all, the argument against stored programs is simply not
true. SQL DML statements, like the …
[Read more]