Have you tried using GenericCursorType for your cursor type? That works for
me. (I can give you a sample stored proc that's working for me, if that
would be helpful.)
- Original Message -
From: Richard Crawford [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 01, 2004
On Tuesday 02 Mar 2004 13:29 pm, Deanna Schneider wrote:
Have you tried using GenericCursorType for your cursor type? That works for
We do something like
ref_cursor is REF CURSOR
and return ref_cursor type.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL
Deanna Schneider wrote:
Have you tried using GenericCursorType for your cursor type? That works for
me. (I can give you a sample stored proc that's working for me, if that
would be helpful.)
I'd appreciate that.I tried using GenericCursorType, and the SP would
not compile, throwing this
Rob wrote:
Did you figure out what datatype it is having problems with? i.e. only
selecting one field at a time. Can it get just an int ok?
All of the datatypes seem to match up just fine.I've gone out of my
way to make them all match.If I remove the refcursor from the
procedure call, then it
==
And here is where it is called in my Cold Fusion page:
==
cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo
cfprocparam type=in value=#cookieID#
Did you figure out what datatype it is having problems with? i.e. only
selecting one field at a time. Can it get just an int ok?
On Mon, 2004-03-01 at 16:38, Richard Crawford wrote:
Still having issues.
Here is the Stored Procedure in question:
Rob wrote:
Did you figure out what datatype it is having problems with? i.e. only
selecting one field at a time. Can it get just an int ok?
All of the datatypes seem to match up just fine.I've gone out of my
way to make them all match.If I remove the refcursor from the
procedure call, then
Did you figure out what datatype it is having problems with? i.e. only
selecting one field at a time. Can it get just an int ok?
All of the datatypes seem to match up just fine.I've gone out of my
way to make them all match.If I remove the refcursor from the
procedure call, then it gives
Donavan,
I would have contacted you directly, but you didn't include your email
address and I'm not gonna call ya long distance on my employer's nickel.
We use Oracle with Cold Fusion all the time. No problems with stability, but
there are some problems with using clobs.
-d
:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 8:03 PM
To: CF-Talk
Subject: Re: Oracle and Cold Fusion
We use Oracle 8 8i here with a tremendous amount of success. We've had
one issue - that is that our Oracle sits on an IBM box and as a result, I
have problems with number fields. I can write
and
Oracle, they both just pointed the finger at each other and neither was
interested in addressing the problem.
Dave
- Original Message -
From: "Larry Juncker" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, October 05, 2000 9:11 AM
Subject: RE: Oracle
:-)
--
Gavin Lilley
Internet / Intranet Developer
Halesowen College
Tel: 0121 550 1451 Ext: 330
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: 05 October 2000 14:30
To: CF-Talk
Subject: Re: Oracle and Cold Fusion
You are the first others I've heard of with that same
What is the "to_char problem"?
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 9:30 AM
To: CF-Talk
Subject: Re: Oracle and Cold Fusion
You are the first others I've heard of with that same To_Char problem. I
thought it
this, we either avoid using numeric formats in the table or do a
To_Char(column_name) in the SQL to force the data to ASCII.
Dave
- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, October 05, 2000 9:57 AM
Subject: RE: Oracle and Cold Fus
Lilley
Internet / Intranet Developer
Halesowen College
Tel: 0121 550 1451 Ext: 330
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: 05 October 2000 14:30
To: CF-Talk
Subject: Re: Oracle and Cold Fusion
You are the first others I've heard of with that same To_Char
I think itt's because Oracle has a large market share for enterprise-level
e-commerce databases...
-Original Message-
From: Peter Theobald [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 10:23 AM
To: CF-Talk
Subject: RE: Oracle and Cold Fusion
We use Sybase here
: Thursday, October 05, 2000 1:23 PM
To: CF-Talk
Subject: RE: Oracle and Cold Fusion
We use Sybase here, but I've noticed that the vast majority of discussions
are about CF and Oracle. I wonder if that means Oracle is the preferred
database for CF or if it is because it has more problems to discuss than
According to Oracle they power 65% of database enabled sites.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, 6 October 2000 5:00
To: CF-Talk
Subject: RE: Oracle and Cold Fusion
I would have said that the majority are about MS SQL Server and MS
One high-traffic app I developed used Oracle 7.3.4 and CF 4.01 on Solaris. Worked
great on NT with an Access database, died on UNIX with Oracle. Go figure.
---mark
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
We use Oracle 8 8i here with a tremendous amount of success. We've had
one issue - that is that our Oracle sits on an IBM box and as a result, I
have problems with number fields. I can write fine, but when I read back
out using the Native Drivers, number fields come back in EPIDIC, so I have
20 matches
Mail list logo