Status/Resolution/Reason: Closed/Withdrawn/Duplicate
Reporter/Name(from Bugbase): sailendra behera / sailendra behera (sailendra behera)
Created: 11/27/2014
Components: Database
Versions: 11.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Windows 7 SP1 64-bit
Vote Count: 1
Duplicate ID: CF-3865064
Problem Description:
With CF11 update 3 fix for Bug 3808734, dbvarname attribute value is now matching with the parameter name of stored procedures. Before that Coldfusion was considering only the order of parameters.
However with this update we have to add colon (:) before each parameter name as dbvarname value to make it work and it will again be different for different databases like @ for sql server.
Steps to Reproduce:
Run any stored procedure with parameter names passed only without appending : or @.
Actual Result:
Throws CFerror -
character to number conversion error ORA-06512
Expected Result:
It should work with only the parameter names passed
Any Workarounds:
Appending colon (:) before parameter names worked for oracle.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3858665
External Customer Info:
External Company:
External Customer Name: Adi86
External Customer Email:
External Test Config: My Hardware and Environment details:Attachments:
Comments: