Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce
Reporter/Name(from Bugbase): Samson Gonzalez / Samson Gonzalez (Samson Gonzalez)
Created: 12/15/2014
Components: Database
Versions: 11.0
Failure Type: Data Loss
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Critical / Some users will encounter
Locale/System: English / Linux uBuntu 11.10
Vote Count: 2
Problem Description:
When using dbvarname, out type parameters return blank values.
Steps to Reproduce:
Create a (simple) procedure which returns output parameters.
CREATE PROCEDURE getOutParam (
@THEOUTPARAM VARCHAR(100) = NULL OUTPUT
, @THEINPARAM VARCHAR(100)
)
AS
SELECT @THEOUTPARAM = @THEINPARAM
GO
Use cfstoredproc to connect to it and cfprocparam type="out" .
<CFSTOREDPROC PROCEDURE="getOutParam" DATASOURCE="DSN_GOES_HERE" RETURNCODE="No">
<CFPROCPARAM DBVARNAME="@THEOUTPARAM" CFSQLTYPE="CF_SQL_VARCHAR" TYPE="out" VARIABLE="theOutParameter">
<CFPROCPARAM DBVARNAME="@THEINPARAM" VALUE="Hello from ColdFusion!" CFSQLTYPE="CF_SQL_VARCHAR" TYPE="in">
</CFSTOREDPROC>
<CFOUTPUT>#theOutParameter#</CFOUTPUT>
Actual Result:
theOutParameter is blank - it exists, but has no value.
Expected Result:
Page should output "Hello from ColdFusion!"
Any Workarounds:
Remove DBVARNAME from cfprocparam and the value is returned correctly
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3909793
External Customer Info:
External Company:
External Customer Name: LongTimeCFer
External Customer Email:
External Test Config: My Hardware and Environment details:
CF11 Update 3
JConnect 7, using jdbc4 driver
Sybase 15Attachments:
Comments: