> I was in an academic meeting where a professor was
> preaching the reasons why not to use a stored procedure.
> He advised to always use SQL instead of a procedural
> language. Can someone please shed some light on this?
Those who can't do, teach?
Honestly... SQL can't do business logic, auditing, etc. Similarly, by
keeping the data local, stored procedures eliminate the network round
trips required to do complex logic which is sometimes performed by an
external application.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/