Chapter 37 Using Stored Procedures
IN THIS CHAPTER
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.
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 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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
