Wouldn't a reference to a cursor actually be a cursor created on the DB server? A query object would technically be an array right? A cursor is a purlely database construct.
Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----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 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 object ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
