Problem with Oracle Thin JDBC driver
topasJun 11 2008 — edited Nov 20 2014Hello all,
I'm facing the fowling problem:
We switch the default original (directdata drivers) drivers on the colfusion to the latest Oracle Thin JDBC driver 10.2.0.4
With the new drivers we start to get errors on some procedures calls
ex:
<cfif IsDefined("form.dsn")>
<cfset begin_date = '01/01/1900'>
<cfset end_date = '31/12/2199'>
<cfset oldlocale = SetLocale('English (US)')>
<cftry>
<cfstoredproc username="ARPS_APP" password="DEVBPASS" datasource="#form.dsn#"
procedure="auditres.arp_pkg_reporting.summary_audits_adjustments2">
<cfprocparam type="in" cfsqltype="CF_SQL_DATE" dbvarname="begin_date" value="#LSDateFormat(begin_date, 'dd/mm/yyyy')#">
<cfprocparam type="in" cfsqltype="CF_SQL_DATE" dbvarname="end_date" value="#LSDateFormat(end_date, 'dd/mm/yyyy')#">
<cfprocresult name="qView">
</cfstoredproc>
<cfdump var="#qView#">
<cfcatch type="any">
<cfdump var="#cfcatch#">
</cfcatch>
</cftry>
</cfif>
I got the fowling error:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SUMMARY_AUDITS_ADJUSTMENTS2' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
which is true because the Oracle procedure is:
PROCEDURE summary_audits_adjustments2(begin_date IN DATE, end_date IN DATE, p_cursor OUT cursor_type);
and I'm not given the 3rd parameter
So, how can this procedure as always run with the directdata drivers (the default cold fusion drivers)?
Is there any workaround to put the code running with the Oracle Thin JDBC driver?
Thank you in advance.