<@U0E7BH32S> I may have something for you to try. ...
# lucee
p
@mauzer I may have something for you to try. It just dawned on me when you posted your sample code. You are using the script syntax and that may be the issue. I'm not sure if that is absolutely the case but it's worth a try. You see in our app, we have some CFML tags/methods that for one reason or another are easier to code in the tag construct. So we have a mechanism to put all these in a .cfm that is code with tags. We use this for CFMAIL, CFHTTP, and low and behold the CFSTOREDPROC tag. So here is the wrapper for the CFStoredProc tag we use:
Copy code
<!--- Wrapper for the CFSTOREDPROC tag. --->
<cffunction name="cfmlStoredProd" returntype="any" access="private" output="false">
  <cfargument name="procedure" type="string" required="true">
  <cfargument name="body" type="string" required="true">

  <cfset local.rv = StructNew()>

  <cfstoredproc datasource="mydatasource" procedure="#arguments.procedure#">
    <cfprocparam value="#arguments.body#" cfsqltype="cf_sql_varchar" type="in">
    <cfprocparam variable="local.rv.result" cfsqltype="cf_sql_varchar" type="out">
    <cfprocresult name="local.rv.query" resultset=2>
  </cfstoredproc>

  <cfset local.rv.result = DeSerializeJson(local.rv.result)>

  <cfreturn local.rv>
</cffunction>
a
How did we conclude this is a tags v script thing, when the Jira ticker relating to the issue just says "can't use
<cfstoredproc>
to call PGSQL procs", and the original example code is in tags? And yer not really addressing the OP's question, which was how to
call
a proc as opposed to using
<cfstoredproc>
?