Re: Passing a Ref_cursor to Oracle Stored procedure

2011-07-29 Thread Dave Smith
thanks guys. appreciate the response. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Passing a Ref_cursor to Oracle Stored procedure

2011-07-22 Thread Dave Smith
Has anyone ever passed a cf_sql_refcursor as an IN param to an oracle stored proc? I am getting the following error when I try it: [Macromedia][Oracle JDBC Driver]Unable to determine the type of the specified object. The proc works when called from another procedure w/ in Oracle but not

RE: Passing a Ref_cursor to Oracle Stored procedure

2011-07-22 Thread Mark A. Kruger
-Original Message- From: Dave Smith [mailto:cyl...@yahoo.com] Sent: Friday, July 22, 2011 11:09 AM To: cf-talk Subject: Passing a Ref_cursor to Oracle Stored procedure Has anyone ever passed a cf_sql_refcursor as an IN param to an oracle stored proc? I am getting the following error when I try

Re: Passing a Ref_cursor to Oracle Stored procedure

2011-07-22 Thread James Holmes
The short answer is that you can't do this from CF. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 23 July 2011 00:09, Dave Smith cyl...@yahoo.com wrote: Has anyone ever passed a cf_sql_refcursor as an IN param to an oracle stored proc?  I am getting the following