Carabetta <[EMAIL PROTECTED]>
Date: Fri, 3 Sep 2004 14:03:52 -0400
Subject: Re: Cold Fusion and Oracle "Unsupported Data Conversion"
To: CF-Talk <[EMAIL PROTECTED]>
On Fri, 3 Sep 2004 13:51:20 -0400, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> Dave which version of
On Fri, 3 Sep 2004 13:51:20 -0400, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> Dave which version of the Oracle JDBC drivers are you using?
>
Using the script at the below URL, this is what I get:
[Macromedia][Oracle JDBC Driver]Driver Version: 3.1.003921002406001721
Script:
http://www.bpurcell
Dave which version of the Oracle JDBC drivers are you using?
-Adam
- Original Message -
From: Dave Carabetta <[EMAIL PROTECTED]>
Date: Fri, 3 Sep 2004 13:23:19 -0400
Subject: Re: Cold Fusion and Oracle "Unsupported Data Conversion"
To: CF-Talk <[EMAIL PROTECTED]>
On Fri, 3 Sep 2004 13:15:31 -0400, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> Yeah, according to Forta one of the major reasons they relased the 6.1
> Updater was because they got some new drivers made for Blackstone and
> didnt want to make us wait for them. Previously the lastest dataDirect
> dr
e for each application to manage clobs, but I'd like to
get it to work with stored procedures.
-Adam
- Original Message -
From: Deanna Schneider <[EMAIL PROTECTED]>
Date: Fri, 3 Sep 2004 10:46:28 -0500
Subject: Re: Cold Fusion and Oracle "Unsupported Data Conversion"
To: CF-T
I'd be interested to hear how the Oracle drivers work for you. We had to
roll back from the latest MM drivers. But, I don't think they've tried any
of the Oracle ones. Are there new drivers with this latest release? It
hasn't been installed here yet.
- Original Message -
From: "Adrocknaph
rect 3.2 drivers not dealing with
Oracle deadlocks very well)
-Adam
- Original Message -
From: Deanna Schneider <[EMAIL PROTECTED]>
Date: Fri, 3 Sep 2004 08:45:29 -0500
Subject: Re: Cold Fusion and Oracle "Unsupported Data Conversion"
To: CF-Talk <[EMAIL PROTECTED]>
Not Adrocknaphobia, but as far as we'er concerned Don't know - the
updated drivers crash our whole system. :(
- Original Message -
From: "Thomas Chiverton"
> Do you still see the error with the updated drivers from the Updater ?
>
[Todays Threads]
[This Message]
[Subscription]
I'd found that out, too, and ended up adding error catching in the PL/SQL to
always make sure that I opened the ref cursor and passed it back, even if it
was empty.
- Original Message -
From: "Adrocknaphobia"
> ** this is a response to a post from 3/9/2004 which never seemed to be
> reso
On Thursday 02 Sep 2004 22:04 pm, Adrocknaphobia wrote:
> This is def a driver/cfmx issue as you will not see this error in any
> form in SQL*Plus.
Do you still see the error with the updated drivers from the Updater ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
emai
** this is a response to a post from 3/9/2004 which never seemed to be
resolved **
Explanation of CFMX Oracle JDBC database error "Unsupported Data Conversion"
This issue occurs when using RefCursors to return queries from oracle
via a stored procedure.
When you declare a RefCursor it is NULL un
Janet Schmitt wrote:
> 3. Remove the close cursor statement from the package body.
Janet,
Turns out that #3, above, was all that I needed to do. I feel kinda
silly (why would I want to close the cursor if I wanted to read it later
on?!!?), but now the thing works!
Thank you very much!
--
> >
>
> is unnecessary in CFMX+.
agreed and i commented it.But, no change.
as i said before it works with ODBC SOCKET connection on my local machine but not with oracle JDBC THIN driver on dev server :((
thanks to the tech note by macromedia...here i found some info in the following link.
".
I wonder if it does not like the way you are passing the value 1881. Try
to set a variable to 1881 and pass that as a parameter.
Something like the following (I am not sure if I have the syntax exactly
right):
value="#cstudentid#" cfSqlType="cf_sql_numeric" variable="studen
sampath nellutla wrote:
>
Based on my own understanding, this line:
>
is unnecessary in CFMX+.
>
>
Now if only I could find out what's necessary to make MY situation work out!
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
Janet Schmitt wrote:
> Richard -
>
> What is the format of the table tblStudentInfo? What are the datatypes
> specified for sFirst, sLast, sOrient and studentId?
>
> What is the CFSTOREDPROC code that was used to call this procedure?
>
> Janet.
Janet,
Here is the table definition:
=
Richard -
What is the format of the table tblStudentInfo? What are the datatypes
specified for sFirst, sLast, sOrient and studentId?
What is the CFSTOREDPROC code that was used to call this procedure?
Janet.
At 09:45 AM 3/9/2004 -0800, you wrote:
>Janet,
>
>Thanks for the suggestion. I tried
> connection on (oracle thin client) development server and throws
> following error.
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SPL_PROC_SUMMARY' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
-sampath
[Todays Threads]
[This Message]
[Subs
Stace,
How did you resolve the issue? I think I'm having the same problem.
>
>
> _
>
> From: Doug Keen [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 08, 2004 2:19 PM
> To: CF-Talk
> Subject: Re: Cold Fusion and Oracle
>
>
>
> I'v
Janet,
Thanks for the suggestion. I tried it, but continue to receive the
"unsupported data conversion" error.
This is getting mighty frustrating.
Janet Schmitt wrote:
> I would try something like this for the Oracle portion:
>
> CREATE OR REPLACE
> PACKAGE schemaname.studentpackage
> IS
>
Nick Han wrote:
> You need the ref cursor. "types.cursorType"---don't take this out.
>
>
>>> studentInfo types.cursorType;
>
>
> did you declare "types.cursorType" in the package spec?, and it has to be a ref cursor type!
>
> example: TYPE cursorType IS REF CURSOR; <= you need this l
i am just wondering why my Package.procedure works fine on my local machine which uses ODBC SOCKET connection and fails when i use JDBC connection on (oracle thin client) development server and throws following error.
any help would be appreciated.
thanks,
-sampath
here is my procedure and cf code
essage-
> From: Janet Schmitt [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 9, 2004 01:52 AM
> To: 'CF-Talk'
> Subject: Re: Cold Fusion and Oracle
>
> I would try something like this for the Oracle portion:
>
> CREATE OR REPLACE
> PACKAGE schemaname.studen
I would try something like this for the Oracle portion:
CREATE OR REPLACE
PACKAGE schemaname.studentpackage
IS
TYPE student_type_ref_cursor IS REF CURSOR;
PROCEDURE test_dlc_sp_getStudentInfo(studentID IN number,
student_cursor IN OUT student_type_ref_cursor);
END;
Create or replace pac
04 2:19 PM
To: CF-Talk
Subject: Re: Cold Fusion and Oracle
I've had similar issues when migrating a CF/Oracle app from CF 4.5 to CF
6.1. During that adventure I found this resource:
http://www.blinex.com/~sam/CF_SQL_TYPES.cfm
This chart maps CF_SQL_TYPE's to types specific to differen
Cold Fusion and Oracle
The endless issues go on. Sigh.
Does anyone know of a very good resource detailing the issues involved
with hooking Cold Fusion up to Oracle?
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [
You need the ref cursor. "types.cursorType"---don't take this out.
>> studentInfo types.cursorType;
did you declare "types.cursorType" in the package spec?, and it has to be a ref cursor type!
example: TYPE cursorType IS REF CURSOR; <= you need this line in the package spec or else it
It yields this error:
Variable GETNAME is undefined
Rob wrote:
> what does
>
> yield?
>
> On Mon, 2004-03-08 at 15:25, Richard Crawford wrote:
>
>>Well, I altered the stored procedure as follows:
>>
>>=
>>PROCEDURE test_dlc_sp_getStudentInfo (
>> s
what does
yield?
On Mon, 2004-03-08 at 15:25, Richard Crawford wrote:
> Well, I altered the stored procedure as follows:
>
> =
> PROCEDURE test_dlc_sp_getStudentInfo (
> studentID IN number
>
> )
>
> as
>
> studentInfo types.cursorType;
>
Well, I altered the stored procedure as follows:
=
PROCEDURE test_dlc_sp_getStudentInfo (
studentID IN number
)
as
studentInfo types.cursorType;
sFirst varchar2(50);
sLast varchar2(50);
sOrient char(1);
begin
open student
Adrocknaphobia wrote:
> Sorry, missed the begining of the thread, why do you guys think its an issue with JDBC?
Hi, Adam.
This is the error message I've been receiving:
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Unsupported data conversion.
--
Richard S. Crawford
Program
Adrocknaphobia wrote:
> Use SQL*Plus to test your procedures.
Thanks. I've done so, and they both compile and run fine. It's where
I'm trying to return the ref cursor to Cold Fusion that it stops working.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http
Sorry, missed the begining of the thread, why do you guys think its an issue with JDBC?
-Adam
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 8, 2004 10:57 PM
> To: 'CF-Talk'
> Subject: RE: Cold Fusion and Oracle
>
&
> Use SQL*Plus to test your procedures.
... but that won't tell him why they're not working through JDBC!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Use SQL*Plus to test your procedures.
> -Original Message-
> From: Richard Crawford [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 8, 2004 10:19 PM
> To: 'CF-Talk'
> Subject: Re: Cold Fusion and Oracle
>
> Dave Watts wrote:
>
> >>I'l
Dave Watts wrote:
>>I'll look into ViennaSQL. I currently use the free version
>>of TOAD, which doesn't (as far as I can tell) allow me to
>>test stored procedures.
>
>
> Well, the thing we want to test specifically is what happens when you call
> it through JDBC. I don't think TOAD uses JDBC
Doug Keen wrote:
> Is "types.cursorType" a REF CURSOR (not your plain-vanilla CURSOR)? If not, I think that may be another potential cause of your error... try changing types.cursorType to be a REF CURSOR and delete your "FETCH ... INTO" statement from the proc.
Hm. It actually IS a REF CURSOR.
Is "types.cursorType" a REF CURSOR (not your plain-vanilla CURSOR)? If not, I think that may be another potential cause of your error... try changing types.cursorType to be a REF CURSOR and delete your "FETCH ... INTO" statement from the proc.
Doug Keen
Senior Consultant, The Seva Group
http://ww
Nick Han wrote:
> Richard, I think in order to call an Oracle stored procedure through Cold Fusion, you need to create a package spec.
> Don't think you can solely reference the procedure name directly.
>
> Create a package spec and put your procedure in the package body. After you have done tha
Doug Keen wrote:
> I've had similar issues when migrating a CF/Oracle app from CF 4.5 to CF 6.1. During that adventure I found this resource:
> http://www.blinex.com/~sam/CF_SQL_TYPES.cfm
>
> This chart maps CF_SQL_TYPE's to types specific to different database platforms, including Oracle. In y
I've had similar issues when migrating a CF/Oracle app from CF 4.5 to CF 6.1. During that adventure I found this resource:
http://www.blinex.com/~sam/CF_SQL_TYPES.cfm
This chart maps CF_SQL_TYPE's to types specific to different database platforms, including Oracle. In your case, you might have s
Richard, I think in order to call an Oracle stored procedure through Cold Fusion, you need to create a package spec.
Don't think you can solely reference the procedure name directly.
Create a package spec and put your procedure in the package body. After you have done that, modify your calling co
> I'll look into ViennaSQL. I currently use the free version
> of TOAD, which doesn't (as far as I can tell) allow me to
> test stored procedures.
Well, the thing we want to test specifically is what happens when you call
it through JDBC. I don't think TOAD uses JDBC.
Dave Watts, CTO, Fig Leaf
Dave Watts wrote:
>>I have a stored procedure written in PL/SQL, which I'm
>>attempting to call from Cold Fusion, but only errors are
>>generated.
>>
>>Here is the stored procedure:
>
>
> Unfortunately, it didn't come through. But anyway, have you tried calling
> this stored procedure from SQL
> I have a stored procedure written in PL/SQL, which I'm
> attempting to call from Cold Fusion, but only errors are
> generated.
>
> Here is the stored procedure:
Unfortunately, it didn't come through. But anyway, have you tried calling
this stored procedure from SQL*Plus? How about from anothe
Richard Crawford wrote:
> Kristopher Pilles wrote:
>
>
>>What kind of issues are ya having? I have use CF and oracle together
>>extensively... perhaps i can help
>
>
> Kristopher,
>
> I've posted about my issues before, but I'll happily do so again. :)
>
> I have a stored procedure written
Kristopher Pilles wrote:
> What kind of issues are ya having? I have use CF and oracle together
> extensively... perhaps i can help
Kristopher,
I've posted about my issues before, but I'll happily do so again. :)
I have a stored procedure written in PL/SQL, which I'm attempting to
call from
What kind of issues are ya having? I have use CF and oracle together
extensively... perhaps i can help
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Monday, March 08, 2004 2:11 PM
To: CF-Talk
Subject: Cold Fusion and Oracle
The endless issues go on
The endless issues go on. Sigh.
Does anyone know of a very good resource detailing the issues involved
with hooking Cold Fusion up to Oracle?
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Today
Plunkett, Matt wrote:
>
> -Original Message-
> From: Richard Crawford
> Sent: Tuesday, February 24, 2004 4:12 PM
> To: CF-Talk
> Subject: Re: Cold Fusion and Oracle Stored Procedures
>
>
> > > Can you run your procedure directly in Oracle?
>
&g
-Original Message-
From: Richard Crawford
Sent: Tuesday, February 24, 2004 4:12 PM
To: CF-Talk
Subject: Re: Cold Fusion and Oracle Stored Procedures
> > Can you run your procedure directly in Oracle?
> It compiles just dandy.
But what happens when you run it? Do you get th
Plunkett, Matt wrote:
>
> -Original Message-
> From: Richard Crawford
> Sent: Tuesday, February 24, 2004 3:24 PM
> To: CF-Talk
> Subject: Re: Cold Fusion and Oracle Stored Procedures
>
>
> > CREATE OR REPLACE procedure dlc_sp_getStudentInfo (
> >
-Original Message-
From: Richard Crawford
Sent: Tuesday, February 24, 2004 3:24 PM
To: CF-Talk
Subject: Re: Cold Fusion and Oracle Stored Procedures
> CREATE OR REPLACE procedure dlc_sp_getStudentInfo (
> studentID IN int,
> studentInfo in out types.cursorType
> )
On Tue, 2004-02-24 at 12:23, Richard Crawford wrote:
I know you are not supposed to, but try casting sFirst etc to varchar
(not varchar2) just to see if that fixes the unknown type problem.
... still looking...
> Rob Rohan wrote:
>
> > That just passes along the problem from the driver/database
Rob Rohan wrote:
> That just passes along the problem from the driver/database it cant tell
> you the line number of the stored proc if it was not given
Here is the revised SP in Oracle:
CREATE OR REPLACE procedure dlc_sp_getStuden
Rob Rohan wrote:
> On Tue, 2004-02-24 at 11:50, Richard Crawford wrote:
>
>>Thomas Chiverton wrote:
>>
>>
>>>Solution: Use native CFMX drivers. Which is a shame :-(
>>>I dunno if it's worth putting in on the wish list...
>>
>>I figured out to return a ref cursor, and this appears to return a
>>r
On Tue, 2004-02-24 at 11:50, Richard Crawford wrote:
> Thomas Chiverton wrote:
>
> > Solution: Use native CFMX drivers. Which is a shame :-(
> > I dunno if it's worth putting in on the wish list...
>
> I figured out to return a ref cursor, and this appears to return a
> result set fine. However
Thomas Chiverton wrote:
> Solution: Use native CFMX drivers. Which is a shame :-(
> I dunno if it's worth putting in on the wish list...
I figured out to return a ref cursor, and this appears to return a
result set fine. However, now I'm getting an error reading, [Oracle
JDBC Driver]Unsupporte
Thomas Chiverton wrote:
> On Monday 23 Feb 2004 23:37 pm, Richard Crawford wrote:
>
>>more disturbing indications that Oracle Stored Procedures do not return
>>result sets.
>
>
> I am investigating this today / yesterday.
> Using cfprocresult works, with Oracle 9i and CFMX6.1 under weblogic, us
Scott Brady wrote:
> Try swapping the last two cfprocparams. Assuming you're using CFMX,
> CFMX no longer uses the dbvarname attribute (at least for Oracle, not
> sure about other databases), so the order in which you provide the
> parameters needs to match the order they're defined in the pro
On Tuesday 24 Feb 2004 09:46 am, Thomas Chiverton wrote:
> More later :-)
There appears to be an issue with Oracle's JDBC driver and weblogic 7 (fixed
in 8 of course) that prevents the use of stored procs that return result
sets.
I was hoping to use weblogic's jdbc driver, with code like the be
On Monday 23 Feb 2004 23:37 pm, Richard Crawford wrote:
> more disturbing indications that Oracle Stored Procedures do not return
> result sets.
I am investigating this today / yesterday.
Using cfprocresult works, with Oracle 9i and CFMX6.1 under weblogic, using
CFMX 'oracle' datasources.
Some co
Try swapping the last two cfprocparams. Assuming you're using CFMX,
CFMX no longer uses the dbvarname attribute (at least for Oracle, not
sure about other databases), so the order in which you provide the
parameters needs to match the order they're defined in the procedure.
In the procedure,
Plunkett, Matt wrote:
> Don't use a cfprocresult unless you're getting a ref cursor back. Just
> refer to the variable as cookieId.
>
Matt,
Thanks for the suggestion. But as I research this, I'm finding more and
more disturbing indications that Oracle Stored Procedures do not return
resul
Don't use a cfprocresult unless you're getting a ref cursor back. Just
refer to the variable as cookieId.
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 4:56 PM
To: CF-Talk
Subject: Cold Fusion and Oracle Stored Procedures
I am having difficulty passing values from an Oracle Stored Procedure to
Cold Fusion.
Here is the stored procedure:
==
CREATE OR REPLACE procedure dlc_sp_verifyLogin (
sLogin IN varchar2,
sPassword IN varchar2,
sRemoteAddr IN varchar2,
sBrowser IN varc
66 matches
Mail list logo
