Re: CF and Oracle Ref Cursors

Thanks for the tip. Unfortunately, as I was laid off this morning, I'm afraid the urgency has diminished somewhat. Matt Osbun Unemployed CFGeek http://www.figleaf.com/ I'm so sorry you were laid off, Matt. Good luck finding a new job! Judith Dinowitz House of Fusion

Re: CF and Oracle Ref Cursors

Guys, I'm revisiting this issue as it has popped up in CF9 and my oracle calls. Has anyone seen a known fix for the current issue Coldfusion has with the Oracl thin-client and how it won't return or use Ref-Cursors? Thanks all * I understand there is a hot-fix in CF 8 but apparently CF 9

Re: CF and Oracle Ref Cursors

On 2012-11-17 14:06, Armando Musto wrote: Guys, I'm revisiting this issue as it has popped up in CF9 and my oracle calls. Has anyone seen a known fix for the current issue Coldfusion has with the Oracl thin-client and how it won't return or use Ref-Cursors? Thanks all * I understand

Re: CF and Oracle Ref Cursors

Thanks for the tip. Unfortunately, as I was laid off this morning, I'm afraid the urgency has diminished somewhat. Matt Osbun Unemployed CFGeek On 9/30/05, Dave Watts [EMAIL PROTECTED] wrote: I'm using an ODBC datasource because, according to the docs, you must use cfprocresult to get a ref

Re: CF and Oracle Ref Cursors

On 9/30/05, Matt Osbun [EMAIL PROTECTED] wrote: I'm no expert on PL/SQL, so I'm hoping I'm missing something easy here. I've got a Oracle 8i stored procedure with two parameters- a varchar IN and a ref cursor OUT. Testing it out, I'm using: cfstoredproc procedure=cla.ipdupes

RE: CF and Oracle Ref Cursors

. The vast majority of our CF querying is done with SQL Server. Matt Osbun Applications Manager Health Systems, International -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Friday, September 30, 2005 1:35 PM To: CF-Talk Subject: Re: CF and Oracle Ref Cursors What

Re: CF and Oracle Ref Cursors

On 9/30/05, Matt Osbun [EMAIL PROTECTED] wrote: As for the first, Coldfusion 7 Standard. Sorry I didn't mention that initially. As for the second... Mostly because of this: java.sql.SQLException: Use of Macromedia JDBC Drivers is restricted. Drivers can only be used with Macromedia server

RE: CF and Oracle Ref Cursors

I'm using an ODBC datasource because, according to the docs, you must use cfprocresult to get a ref cursor from Oracle 8, and can't use cfprocresult with Oracle's ThinClient JDBC drivers. I'm no Oracle expert, but maybe you could use the Oracle JDBC drivers that use the native Oracle client,