tracker issue : CF-4203409

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

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
 
{code:java}
  <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#">
  </cfstoredproc>  
{code}


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> 

Now, 
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.!

Attachments:

Comments:

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