cfquery oracle stored procedure

I had to change the SQL stored procedure to ORacle stored procddure.I am able to successfully execute my modified stored procedure i开发者_Go百科n oracle.

But unable to obtain the query result in CF for the Oracle stored-Procedure.I have used <cfquery>.

Any suggestions or tips to for using an Oracle stored proc/CF-8?

Think you need cfstoredproc, not cfquery.

See manual page for more details.

It does really depend on how it reacts, i'd test your stored proc in oracle sql+plus first, to make sure it returns data, then try it via cfquery or stored procedure...