tracker issue : CF-3971083

select a category, or use search below
(searches all categories and all time range)

cfstoredproc - Last OUTPUT parameter - ColdFusion 11 Update 5

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Matthew Parks / Matthew Parks (Matthew Parks)

Created: 04/16/2015

Components: Database

Versions: 11.0

Failure Type: Data Loss

Found In Build/Fixed In Build: CF11_Final / CF11 Update7

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 16

Listed in the version Issues Fixed doc
Problem Description:Calling a Stored Procedure that has IN and OUT parameters, the LAST OUT parameter variable name is not able to be referenced by code.

Steps to Reproduce:

-- Table creation

create table Test
( id int, 
name varchar2(20), 
name1 varchar2(20),
name2 decimal,
name3 varchar2(20),
name4 varchar2(20),
name5 varchar2(20),
name6 varchar2(20),
name7 decimal,
name8 varchar2(20),
name9 varchar2(20),
name10 varchar2(20),
name11 varchar2(20));

-- Data insertion
insert into Test values(1, 'SomeText', 'SomeText', 23432.45, 'SomeText', 'SomeText', 'SomeText', 'SomeText', 34.34, 'SomeText', 'SomeText', 'SomeText', 'SomeText');
insert into Test values(2, 'SomeText', 'SomeText', 324.23, 'SomeText', 'SomeText', 'SomeText', 'SomeText', 56.5, 'SomeText', 'SomeText', 'SomeText', 'SomeText');
insert into Test values(3, 'SomeText', 'SomeText', 23232.2, 'SomeText', 'SomeText', 'SomeText', 'SomeText', 78.6, 'SomeText', 'SomeText', 'SomeText', 'SomeText');
insert into Test values(4, 'SomeText', 'SomeText', 7665.5, 'SomeText', 'SomeText', 'SomeText', 'SomeText', 789.5, 'SomeText', 'SomeText', 'SomeText', 'SomeText');

--create stored procedure
create or replace procedure spTest (idd in number, name out varchar2, name1 out varchar2, name2 out decimal, name3 out varchar2, name4 out varchar2, name5 out varchar2, name6 out varchar2, name7 out decimal, name8 out varchar2, name9 out varchar2, name10 out varchar2, name11 out varchar2) as 
SELECT name, name1, name2, name3, name4, name5, name6, name7, name8, name9, name10, name11 into name, name1, name2, name3, name4, name5, name6, name7, name8, name9, name10, name11 FROM Test where id = idd;

--Calling Stored ptocedure

<cfstoredproc procedure="spTest" datasource="oracle11g">
   <cfprocparam type="IN" cfsqltype="CF_SQL_INTEGER" value="2">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name1">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_DECIMAL" variable="name2">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name3">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name4">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name5">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name6">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_DECIMAL" variable="name7">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name8">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name9">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name10">
   <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="name11">

Actual Result:

Event Name: onRequest
error message: Variable NAME11 is undefined.
error detail: 
The contents of the tag stack are:
Template: C:\inetpub\\CF11_test.cfm 
Line: 31 
ID: ?? 

Where line 31 is the code #name11#<br> as you have given it.

Expected Result:

name11 has the returned value of the Stored Procedure like Name 1 - 10 do.

Any Workarounds:

At this point I do not know of a work around other than not INSTALLING update 5 for CF11.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3971083

External Customer Info:
External Company:  
External Customer Name: Matthew
External Customer Email:  
External Test Config: My Hardware and Environment details:

1. ORACLE 11g

2. Windows Server 2012 R2 Standard Edition



Please let me know if you need any additional information.
Comment by External U.
7788 | April 16, 2015 09:20:37 AM GMT
Matthew, Could you share the CF Settings Summary, Database Version and the OS that you are using. Also what is the db driver that you are using. Is it the one shipped with CF or are you using some other driver? We will have to try on a similar environment to reproduce the issue. You can send the details to
Comment by Himavanth R.
7789 | April 16, 2015 11:38:18 PM GMT
User test configurations details: My Hardware and Environment details: 1. ORACLE 11g 2. Windows Server 2012 R2 Standard Edition
Comment by Vamseekrishna N.
7790 | April 17, 2015 01:00:35 AM GMT
I have sent the requested additional information to your email directly. We use both 10g and 11g and two drivers. One that shipped with CF and another that was distributed by ORACLE (ojdbc6.jar), neither of these DSN Drivers work. OR I should say exhibit the same behavior as described in the bug report.
Comment by External U.
7791 | April 17, 2015 07:23:15 AM GMT
we are having similar issues on Win08R2/Oracle11g using latest Oracle Thin drivers
Comment by External U.
7792 | April 17, 2015 01:35:00 PM GMT
we cannot apply this update as it would severely impact functionality of our enterprise application.
Vote by External U.
7823 | April 20, 2015 09:14:52 AM GMT
I just upgraded our server from CF9 to CF11 Standard, Update 5 and was experiencing this same issue breaking our code. Uninstalling Update 5 resolved the issue. OS - Windows Server 2012 R2 x64 DB - MSSQL 2008 R2 x64 Workgroup Edition
Comment by External U.
7793 | April 23, 2015 11:49:17 PM GMT
Show stopper issue that breaks any stored procedure query expecting an output parameter.
Vote by External U.
7824 | April 23, 2015 11:56:13 PM GMT
Show stopper. We need to update our production environment soon to comply with a mandate to fix a vulnerability in Update 4. Worst case scenario, I will have to change the code to have an extra dummy variable on EVERY Stored Procedure across our site.
Vote by External U.
7825 | April 24, 2015 12:19:21 PM GMT
Same issue utilizing Microsoft Windows Server 2008R2 and Oracle 11G. Will break the software application used on our servers
Vote by External U.
7826 | April 24, 2015 12:27:32 PM GMT
Hi Guys, We have been trying to replicate this issue with our test environment and We are unable to replicate this issue. Even I tried sharing the code with Matthew which is working at my end and it is failing at his setup. It looks like there is an edge case or some configuration which we do not have on our server. I would really appreciate if someone can join my connect session and show me this issue? Please contact me:
Comment by Nimit S.
7794 | April 27, 2015 06:47:34 AM GMT
This bug prevents us from applying the update, this is a major issue for us.
Vote by External U.
7827 | April 27, 2015 09:17:45 AM GMT
Hi, I have replicate this issue with this code: --------- SQL ------------ ALTER PROCEDURE sp_TestCF11 @a INT , @b INT OUTPUT , @c INT OUTPUT AS BEGIN SET NOCOUNT ON; SET @b = @a END GO --------- CFM ------------ <cfstoredproc procedure="sp_TestCF11"> <cfprocparam value="1" type="in" cfsqltype="cf_sql_integer"> <cfprocparam variable="r" type="out" cfsqltype="cf_sql_integer"> <cfprocparam variable="p" type="out" cfsqltype="cf_sql_integer"> </cfstoredproc> <cfoutput> r: #r#<br> p: #p#<br> </cfoutput> --------- OUTPUT ------------ r: 1 p:Variable P is undefined. This is my Environment: Server Product ColdFusion Version 11,0,05,293506 Tomcat Version Edition Developer Operating System Windows 8 OS Version 6.2 SQL SERVER: 12.0.2000 Please fix this bug
Comment by External U.
7795 | April 27, 2015 09:43:39 AM GMT
Hi Emanuele, This code is working at my end. Is it possible if you can share your screen so that I can troubleshoot it further?
Comment by Nimit S.
7796 | April 27, 2015 11:53:45 AM GMT
I can apply update 5 to Development at connect with you for screen share at 3 PM ET April 27. Will that work? I have sent email to you stating as such as well.
Comment by External U.
7797 | April 27, 2015 01:23:57 PM GMT
We discovered that issue only comes up when ColdFusion DEBUG information is being returned. If Debug is turned off the problem does not exist. Wanted to share with others so it MIGHT be ok in production env. as long as DEBUG is off there.
Comment by External U.
7798 | April 27, 2015 02:07:22 PM GMT
Thanks Matthew for coming on a call and help us debugging this issue :)
Comment by Nimit S.
7799 | April 27, 2015 02:09:25 PM GMT
Hi Nimit Sharma, I confirm Matthew, If Debug is turned off the problem does not exist. Please fix this issue.
Comment by External U.
7800 | April 28, 2015 02:07:52 AM GMT
Please fix this issue. We need the Debug On when tracking errors and issues.
Comment by External U.
7801 | May 06, 2015 03:38:00 PM GMT
Please fix this issue. We need the Debug On when tracking errors and issues.
Vote by External U.
7828 | May 06, 2015 03:38:53 PM GMT
We need to be able to test code with debug running. This should go without saying. Please get a quick fix on this.
Vote by External U.
7829 | May 06, 2015 03:45:07 PM GMT
Hi Arwin, This issue is fixed. Please drop an email to to get an early access to the hotfix. Regards, Nimit
Comment by Nimit S.
7802 | May 06, 2015 11:36:37 PM GMT
This is mission critical for my development team and business. This needs to be fixed as an Urgent matter. Jeff Dumont
Vote by External U.
7830 | May 07, 2015 11:03:28 AM GMT
Thank you Nimit! I emailed to They sent me instructions how to apply the fix. It is now working.
Comment by External U.
7803 | May 07, 2015 02:47:07 PM GMT
I am encountering this when trying to update data. This process is fundamental to more than one of our 50 applications. We are trying to upgrade from CF 9 to CF 11 and this may prevent the upgrade.
Vote by External U.
7831 | May 11, 2015 03:06:41 PM GMT
Needs to be fixed, this would seriously impact our enterprise client.
Comment by External U.
7804 | May 12, 2015 12:02:44 PM GMT
This is a mighty bug. Please release an update ASAP.
Vote by External U.
7832 | May 21, 2015 02:58:08 AM GMT
Deal breaker for us. We can not upgrade to CF 11 until this issue is resolved.
Vote by External U.
7833 | May 29, 2015 08:11:18 AM GMT
Same issue on Mac OS X (10.10.3) connecting to MS SQL Server 2005. This is serious, please fix this bug.
Comment by External U.
7805 | June 01, 2015 11:14:39 AM GMT
@Graham, MaryJo As others have noted earlier in the bug, this happens only when the "debug" is on. Are you running your production server with "debug" turned on? Anyways, the bug is fixed and you can reach out to for the fix.
Comment by Rupesh K.
7806 | June 01, 2015 10:37:30 PM GMT
This is huge; upgrading to Update 5 has taken down my entire site because of the last output var / parameter not being accessible.
Vote by External U.
7834 | June 10, 2015 07:11:18 AM GMT
This is a serious issue for us as well. I found this issue the hard way. I had 2 servers one with hotfix 4 applied and one with hotfix 5 applied. The proc call was working on the server that had only hotfix 4 applied. It didnt make sense in the beginning but on close inspection I figured out what was the difference between 2 servers. Please fix this ASAP. CF 11 64 bit Windows 2008 R2 64 bit IIS 7.5
Comment by External U.
7807 | June 10, 2015 02:44:18 PM GMT
Fix this ASAP please. See my comments as well.
Vote by External U.
7835 | June 10, 2015 02:45:42 PM GMT
Where can I get the hotfix that fixes this problem?
Comment by External U.
7808 | June 11, 2015 09:51:29 AM GMT
Please reach out to, if you need an early access to this hotfix. This issue only occurs if you have debugging option enabled.
Comment by Nimit S.
7809 | June 11, 2015 09:55:44 AM GMT
Yes - I have debug enabled. I just requested the hotfix. Thank you.
Comment by External U.
7810 | June 11, 2015 10:00:27 AM GMT
After update, I got exactly same problem as described here, please fix this bug.
Vote by External U.
7836 | June 24, 2015 02:26:37 PM GMT
This is a reminder of the value in having independent QA resources - who perform regular & full regression testing. The more you know....
Vote by External U.
7837 | July 01, 2015 04:36:57 PM GMT
Issue does not appear to be fixed. On version 11,0,05,293506 connecting to Oracle 12c and CFAdmin states that there are not updates available. If I have to email support to get a hotfix, this should not be marked as closed.
Comment by External U.
7811 | July 14, 2015 12:07:34 PM GMT
Hi Matthew, I understand your concern. This issue is fixed and targeted for the upcoming update of ColdFusion 11. We have provided an early access to this fix, if it is hampering the development workflow.
Comment by Nimit S.
7812 | July 22, 2015 12:36:54 AM GMT
Just adding my vote... Do we know when the next update comes out? I don't know if I want to deploy the hotfix to all of my clients' servers.
Vote by External U.
7838 | July 22, 2015 08:11:00 AM GMT
Just updated to update 6 and this BUG with the Debug information is still present in update 6. Thanks.
Comment by External U.
7813 | August 27, 2015 01:28:45 PM GMT
Adobe, Can you please populate this ticket's "Fixed In Build" field w/ the version number? Can you please -always- populate a ticket's "Fixed In Build" field w/ the version number? Thanks!, -Aaron
Comment by External U.
7814 | August 27, 2015 02:24:28 PM GMT
Not sure if it is related to this, but we have been testing the Update 6 with debug off, and while it doesn't have this error, it DOES have severe performance issues with the stored proc calls, causing the CPU to go up to 100% and page loads timing out and taking extremely long times. We had to roll back to Update 4 for now. Just a warning to anyone else to be sure to test this latest update whether you have debug on or not.
Comment by External U.
7815 | September 01, 2015 11:34:32 AM GMT
I was able to get the HotFix from Adobe mentioned below and applied that to Update 6, and that seems to also correct the performance issue we ran into even with debugging turned off. Anyone planning to upgrade should make sure to have that information and test their process out before moving past Update 4.
Comment by External U.
7816 | September 01, 2015 01:10:50 PM GMT
Hi, I have CF applications with heavy use of SQL Stored Procedures and it has been quite a frustrating last 4 months trying to migrate CF8 to CF11 with performance issues spiking the CPU. After rolling back to Upgrade 3 it runs very well.... Please fix asap. I thank a genius man who helped troubleshoot this for me last month - I have lost a lot of momentum messing with infrastructure all this time and spending money I shouldn't have had to spend
Comment by External U.
7817 | September 28, 2015 04:29:19 PM GMT
Adobe needs to stop closing tickets as fixed when the fix is NOT released officially to users. People think that means it's fixed in the latest update and that is NOT the case here.
Comment by External U.
7818 | September 28, 2015 06:00:11 PM GMT
+1 to Mary's comment. Adobe, if you can't specify the "Fixed In Build" field when closing a ticket, then please leave the ticket open. Closing tickets w/o filling in that field just causes confusion. Thanks!, -Aaron
Comment by External U.
7819 | September 28, 2015 06:38:05 PM GMT
Nimit, can you please clarify: On July 21, 2015 you posted here "This issue is fixed and targeted for the upcoming update of ColdFusion 11". Then 5 weeks later on Aug. 27th CF11, Update 6 was released, but Matthew reports that this update 6 does NOT fix this problem. What is the status please? Thanks, Byron
Comment by External U.
7820 | November 12, 2015 04:24:15 PM GMT
Hi Byron, Sorry for the inconvenience. This fix is not included in ColdFusion 11 Update 6, because it was only a security hotfix. However, this issue is fixed in ColdFusion 11 Update 7 which is available on pre-release. For more details, please refer the article mentioned below:
Comment by Nimit S.
7821 | November 12, 2015 09:03:33 PM GMT
Verified this is fixed in CF11 Update 7 (build 11,0,07,296330). Debug output no longer breaks the out parameter. Thanks!, -Aaron
Comment by External U.
7822 | December 03, 2015 06:05:19 AM GMT