tracker issue : CF-3943756

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

Calling wrong procedure when calling a Oracle Overloaded Procedure

| View in Tracker

Status/Resolution/Reason: To Test//HaveNewInfo

Reporter/Name(from Bugbase): bharath JT / bharath JT (bharath JT)

Created: 02/22/2015

Components: Database

Versions: 2016,11.0,10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win 2008 Server R2

Vote Count: 0

Problem Description:
When the CFSTORECPROC calls a Overloaded procedure in oracle package, it executes the wrong procedure.
Steps to Reproduce:
sample code snippet attached.
1. Create the Package by executing the wmssp_test_pkg.ora in Oracle DB.
2. load the code test1.cfm in Coldfusion 10 instance
3. Setup datasource to connect to the Oracle DB used in step1.
4. Execute the test1.cfm

Actual Result:
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 1 <br>The error occurred on line 24. 

(param 1) = [type='IN', class='java.lang.String', value='55372666;', sqltype='CF_SQL_CHAR'] , (param 2) = [type='IN', class='java.lang.Integer', value='1', sqltype='CF_SQL_INTEGER'] , (param 3) = [type='IN', class='java.lang.String', value='AD', sqltype='CF_SQL_VARCHAR'] , (param 4) = [type='IN', class='java.lang.String', value='02/09/2015 01:13:25', sqltype='CF_SQL_VARCHAR'] , (param 5) = [type='IN', class='java.lang.String', value='tj159p', sqltype='CF_SQL_CHAR'] , (param 6) = [type='IN', class='java.lang.String', value='Static test for overloaded procedure call', sqltype='CF_SQL_VARCHAR'] , (param 7) = [type='IN', class='java.lang.String', value='N', sqltype='CF_SQL_CHAR'] , (param 8) = [type='IN', class='java.lang.Integer', value='1', sqltype='CF_SQL_INTEGER'] , (param 9) = [type='INOUT', class='java.lang.Integer', value='3', sqltype='CF_SQL_INTEGER'] , (param 10) = [type='OUT', sqltype='CF_SQL_INTEGER'] 

when the semicolon is removed from the value in param1, it executes the procedure with 5 parameter

Expected Result:
should execute the correct procedure with 10 params
Any Workarounds:

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

Watson Bug ID:	3943756

Reason:	BugVerified

External Customer Info:
External Company:  
External Customer Name: bharath
External Customer Email:  
External Test Config: CF 10 with latest drivers fro Oracle

Attachments:

  1. February 22, 2015 00:00:00: 1_overloadProcIssue.zip

Comments:

It is still not fixed. I will follow up with DataDirect
Comment by Nimit S.
8332 | September 22, 2015 01:25:21 AM GMT