Hello,

I am trying to cache the resultset from a stored procedure, and ONLY for this
reason I am calling the procedure using <cfquery>. But for some reason, I am
unable to get this to work. So far I have tried:

<cfquery name="FieldData" datasource="#request.dsn#">
CALL bsad_owner.PKG_BSAD_APPS.prc_report_field_config
('#AppName#', '#screenName#', #gid#)
</cfquery>

and:

<cfquery name="FieldData" datasource="#request.dsn#">
EXEC bsad_owner.PKG_BSAD_APPS.prc_report_field_config
('#AppName#', '#screenName#', #gid#)
</cfquery>

but neither work. I know I have not yet added the 'cachedwithin' bit, but my
first step is to get it to work. The error I get from Oracle is:
PLS-306: wrong number or types of arguments in call to
&apos;PRC_REPORT_FIELD_CONFIG&apos;

and the procedure definition is:

oNbr_RetCode OUT NUMBER,
oVar_RetMsg OUT VARCHAR2,
oRef_FieldData OUT SYS_REFCURSOR,
iVar_AppName IN bsad_applications.application%TYPE,
iVar_Screen IN app_field_config.screen%TYPE,
iNbr_GID IN bsad_users.user_id%TYPE

and I am out of ideas. If anyone has had any experience of this, and can see
what I am doing wrong, I would be very grateful.

Many Thanks,
Stephen