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:346310
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
