Adobe ColdFusion 8 Web Application Construction Kit, Volume 3: Advanced Application Development

Chapter 42. Working with Stored Procedures

<feature><title>In This Chapter</title>

• Why Use Stored Procedures? E75

• Calling Stored Procedures from ColdFusion Templates E79

• Creating Stored Procedures E100

</feature>

Most server-based database systems—SQL Server, Oracle, and Sybase—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.

Note

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 ...