Chapter 37 Using Stored Procedures


Why Use Stored Procedures? 397

Calling Stored Procedures from ColdFusion Templates 398

Most server-based database systems—SQL Server, Oracle, and MySQL—support stored procedures. A stored procedure is a chunk of SQL code that’s given a name and stored as a part of your database, along with your actual data tables. After the stored procedure has been created, you can invoke it in your ColdFusion templates using the <cfstoredproc> tag.


The use of stored procedures in database applications is a relatively advanced topic. It’s not rocket science, but you will be more comfortable working with stored procedures if you are familiar with the SQL concepts introduced in the previous chapter or have ...

Get Adobe ColdFusion 9 Web Application Construction Kit, Volume 2: Application Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.