Hi folks

I hope you can help me. I'm having a terrible time trying to get a query to
work.

I've got a CF MX6.1 Standard system talking to an Oracle 10.0.1 db. CF is
running on Win2003. Oracle (currently) is also running on a Win2003 box. All
is fine. All my CFSTOREDPROCs work. They happily return multiple recordsets
of type sys_refcursor.

The problem is that we're migrating our Oracle onto a Redhat Linux box running
10.0.2. And everything is broken.

All my CFSTOREDPROCs now fail.

If I use a standard Oracle ODBC DSN I get this error:

Network problem, session aborted due to internal error in remote procedure
call, connection closed.

I've created other ODBC drivers, such as the Java oracle OCI or thin
connection and I get this error:

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in
call to 'WEBCONFIG' ORA-06550: line 1, column 7: PL/SQL: Statement
ignored.

My CF commands are:

<CFSTOREDPROC procedure="REG.WEB.webConfig" datasource="ElginOra_beta_oci"
RETURNCODE="no">
<CFPROCPARAM type="In" cfsqltype="CF_SQL_NUMBER" value="#IIf(request.Dev,
DE(1), DE(0))#" null="no">
<CFPROCPARAM type="In" cfsqltype="CF_SQL_VARCHAR" value="#incomingURL#"
null="no">
<CFPROCRESULT NAME="webConfig">
</CFSTOREDPROC>

If I run it as

<CFQUERY name="webConfig" datasource="ElginOra_beta_oci">
{call REG.WEB.webConfig (#IIf(request.Dev, DE(1), DE(0))#, '#incomingURL#')}
</CFQUERY>

I get a proper result back. So there's nothign wrong with my Oracle package.

If I mistype the package name or proc name I get a sensible message back
saying it invalid object. So it's obviously reading the Oracle catalogue ok.

If I just ask it to return a recordset with no IN params it still fails.

I can run CFSTROEDPROCs if it doesn't return a recordset. (unless the jrun
process spikes...)

If I swap the DSN back to the Oracle 10.0.1 version in Win2003 the
CFSTOREDPROC works.

Another symptom is that the jrun process hits 50-100% CPU and sticks there. I
need to restart the CF services to reset it.

I've patched my MX6.1 install, and also patched the DataDirect Sequelink ODBC
Server to version 5.4 which I forlonly hoped would solve my problem. No joy.

Can anyone help? Has anyone had this problem before? I think it might be a
cursor problem, but what? I'm in the process of setting up Oracle 10.0.2 on
Win2003 to ensure it's not an Oracle version problem. But I don't hold out
much hopre for that.

Cheers

-bill-