Re: CFMX, Oracle, store procs, and result sets
bamm! thanks Dave. My developer is happy now, complained about the Live Docs though. :) D On Wed, 9 Mar 2005 11:30:19 -0500, Dave Watts <[EMAIL PROTECTED]> wrote: > > Ok, I have a developer trying to use an SP in Oracle to > > return an actual query result set to CFMX. Is this even > > possible anymore? He followed > > http://livedocs.macromedia.com/coldfusion/7/htmldocs/0313.htm > > but gets > > > > Error Executing Database Query. > > [Macromedia][Oracle JDBC Driver]The specified SQL type is not > > supported by this driver. > > > > The error occurred in > > D:\Inetpub\wwwroot\rmahoney\play\test.cfm: line 12 > > > > 10 : > > 11 :> variable="EmpName"> > > 12 : > > 13 : > > > > looking at the above LiveDoc, seems to be some confusion > > about how to do this. Anyone have an example they would like > > to share? > > Try it without the CFPROCPARAM and just with the CFPROCRESULT. According to > the LiveDoc you mentioned, "You cannot use the cfprocparam tag for Oracle 8 > and 9 reference cursors. Instead, use the cfprocresult tag." > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197978 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMX, Oracle, store procs, and result sets
> Ok, I have a developer trying to use an SP in Oracle to > return an actual query result set to CFMX. Is this even > possible anymore? He followed > http://livedocs.macromedia.com/coldfusion/7/htmldocs/0313.htm > but gets > > Error Executing Database Query. > [Macromedia][Oracle JDBC Driver]The specified SQL type is not > supported by this driver. > > The error occurred in > D:\Inetpub\wwwroot\rmahoney\play\test.cfm: line 12 > > 10 : > 11 :variable="EmpName"> > 12 : > 13 : > > looking at the above LiveDoc, seems to be some confusion > about how to do this. Anyone have an example they would like > to share? Try it without the CFPROCPARAM and just with the CFPROCRESULT. According to the LiveDoc you mentioned, "You cannot use the cfprocparam tag for Oracle 8 and 9 reference cursors. Instead, use the cfprocresult tag." Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197971 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX, Oracle, store procs, and result sets
Ok, I have a developer trying to use an SP in Oracle to return an actual query result set to CFMX. Is this even possible anymore? He followed http://livedocs.macromedia.com/coldfusion/7/htmldocs/0313.htm but gets Error Executing Database Query. [Macromedia][Oracle JDBC Driver]The specified SQL type is not supported by this driver. The error occurred in D:\Inetpub\wwwroot\rmahoney\play\test.cfm: line 12 10 : 11 : 12 : 13 : 14 : looking at the above LiveDoc, seems to be some confusion about how to do this. Anyone have an example they would like to share? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197967 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54