cfprocresult doesn't work

[zax_srb]

Firstly, let me say I am fully aware of the issue regarding using cfprocresult
in MX (in my case 6.1). It seems that has tripped up a lot of people. I am
using Oracle 9i and MX 6.1, and when I run the attatched code I get the error:

[Macromedia][Oracle JDBC Driver]Unsupported data conversion.

And the <cfprocresult name="roles" resultset="1"> line of code is highlighted.

The procedure works as we have run it with just parameters, but as soon as we
try and return the result set, after making the additions to the procedure, we
get the above error. Any ideas?

Thanks in advance for your help,
Stephen

<cfstoredproc
procedure="bsad_owner.PKG_BSAD_APPS.prc_logon"
datasource="#application.datasourceName#"
returncode="no">
<cfprocparam type="out"
dbvarname="oNbr_RetCode"
variable="returnCode"
cfsqltype="cf_sql_varchar"
null="no">
<cfprocparam type="out"
dbvarname="oVar_RetMsg"
variable="returnMessage"
cfsqltype="cf_sql_varchar"
null="no">
<cfprocparam type="in"
dbvarname="iVar_UID"
value="lsso_uid"
cfsqltype="cf_sql_varchar"
null="no">
<cfprocparam type="in"
dbvarname="ivar_PWD"
value="lsso_password"
cfsqltype="cf_sql_varchar"
null="no">
<cfprocparam type="in"
dbvarname="iVar_AppName"
value="#application.applicationName#"
cfsqltype="cf_sql_varchar"
null="no">

<cfprocresult name="roles" resultset="1">
</cfstoredproc>

[paross1]

Since you did not include your stored procedure, I am assuming that you are
using a reference cursor to capture your result set. What drivers are you
using, as you cannot use Oracle's ThinClient JDBC drivers when attempting to
return result sets via reference cursors.

[url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b17.htm#wp1102246[/url]

To use reference cursors in packages or stored procedures, use the
cfprocresult tag. This causes the ColdFusion JDBC database driver to put Oracle
reference cursors into a result set. (You cannot use this method with Oracle's
ThinClient JDBC drivers.)

Phil