use cfprocedure (error in cfprocresult)

[fpal]

Hi all
i use procedure found in oracle name abc
The code is
<CFSTOREDPROC datasource=&quot;y&quot; procedure=&quot;abc&quot;>
<cfprocparam type=&quot;IN&quot; cfsqltype=&quot;CF_SQL_VARCHAR&quot; value=&quot;aaaa&quot; dbvarname=&quot;@helloo&quot;>
<cfprocparam type = &quot;Out&quot; cfsqltype=&quot;CF_SQL_VARCHAR&quot; variable = &quot;z&quot;>
<cfprocresult name=&quot;queryname&quot; resultset=&quot;5&quot;>
</CFSTOREDPROC>
<cfoutput>#queryname.recordcount#</cfoutput>


The error is &quot;Element RECORDCOUNT is undefined in queryname &quot;

PLZ any body have any information about this article reply

Thanks for all

 

[csteinhilber]

Try doing a:

<CFDUMP var=&quot;#queryname#&quot;>

just to see if anything is getting returned at all.

If it still complains, try changing the resultset name. &quot;queryname&quot; might be reserved.
Hope it helps,
-Carl

 

[fpal]

HI
Thanks
But the queryname just a name because the name of query is employeedata
the procedure run in oracle ok and in cfm ok but function recordcount give error
where is the problem
Note (I download hotfix for cfmmx)
Thanks for all

 

[csteinhilber]

So what did the CFDUMP give you?

How many rows?
Hope it helps,
-Carl