Accessing Stored Procedure Return Codes

Many DBMS’ allow stored procedures to return result codes – indicators, counters, status codes, and more. To retrieve these values use to execute the stored procedure instead of , and make sure to set RETURNCODE=”YES” (the default is “NO”). The result code will then be accessible as CFSTOREDPROC.STATUSCODE. (Applies to: ColdFusion 4 (or later))

Leave a Reply