Re: Passing a Ref_cursor to Oracle Stored procedure
thanks guys. appreciate the response. ~| 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:346399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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:346310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Passing a Ref_cursor to Oracle Stored procedure
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
Re: Passing a Ref_cursor to Oracle Stored procedure
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 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