On 9/26/05, wolf2k5 <[EMAIL PROTECTED]> wrote: > On 9/22/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote: > > The Oracle JDBC drivers do no support Ref Cursors. So you can use them > > to call a stored proc, as long as you don't need it to return a > > cfquery object. > > I am not sure what that means: Ref Cursors, etc. > > Can you give me more info or point to any online resource about that? >
If you're returning a query from a stored procedure, for example, the data type of the variable in the Oracle stored procedure would be a REF CURSOR. This REF CURSOR is what the current versions of the DataDirect drivers have a problem with on Oracle 10g R2 (remember, R1 is fine). Stephen Dupre (Macromedia engineer) has noted that he is starting a beta for a set of DataDirect drivers that will fix this problem. If you feel like you need a solution for this is in the near future (i.e., you've upgraded to Oracle 10g R2), then get in touch with him per his e-mail. Regards, Dave. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
