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 <[email protected]> wrote: > > 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 from > CF. > > <cfstoredproc datasource="#application.dsn#" procedure="#insertProc#"> > <cfprocparam type="in" cfsqltype="cf_sql_refcursor" > value="#qUpdatesIDs#"> > </cfstoredproc> > > qUpdatesIDs = a query o ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
