tracker issue : CF-4203409

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

CF2018 - Does not run with existing CFStoreProd wihtout ":" as prefix.! (Only for NUMERIC Parameters)

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Chittesh Mehta / ()

Created: 10/26/2018

Components: Database, Oracle

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF2018 Build 1 /

Priority/Frequency: Normal / All users will encounter

Locale/System: ALL / Win 2012 Server x64

Vote Count: 1

Problem Description:
As per our existing working code
  <cfstoredproc procedure="CF2018_SP_CHECK" datasource="[datasource_name]">
    <cfprocparam dbvarname="P_USER_NAME" cfsqltype="CF_SQL_VARCHAR" type="IN" value="#vUserName#">
    <cfprocparam dbvarname="P_PASSWORD" cfsqltype="CF_SQL_VARCHAR" type="IN" value="#vPassword#">
    <cfprocparam dbvarname="P_COMPANY_ID" cfsqltype="CF_SQL_NUMERIC" type="IN" value="#vCompanyID#">

When  tried this with CF2018,
Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line X. (Line no as the <cfstoredproc Tag> 

After hearing from Tech team, When we change "Only" NUMERIC Parameter with var name as prefix with ":", Its working.
CF_SQL_VARCHAR - Does not need to change for this case.

This is something really basic and it would not be practical when some product has mo than 3 Million lines of code with 8000 Plus CF Pages, IT would NOT BE POSSIBLE TO ADOPT THIS UNEXPLIANABLE Behaviour anc change code for CF Bug.!



If it is working with 'CF_SQL_VARCHAR' why it is not with 'CF_SQL_NUMERIC'. It is really not explainable. CF please look into this. Thanks
Comment by Sandeep K.
29852 | October 26, 2018 10:59:22 AM GMT