I’ve heard for years that using Oracle’s stored procedures is both more efficient and more secure than writing queries against the database. It turns out, not everyone agrees with that and there is quite a bit of room for debate (most of the articles focus on MS-SQL Server and T-SQL, not Oracle and PL/SQL, although some general principles still apply):
- Faster Performance using Oracle Stored Procedures
- Stored Procedures vs. Ad-Hoc SQL
- To SP or not to SP in SQL Server
- Stored procedures are bad, m’kay?
I was still interested in how to use Oracle stored procedures with ColdFusion, though.
Continue reading Oracle stored procedures and ColdFusion