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 6:38 PM
Subject: Oracle and Cold Fusion
> Still having issues.
>
> Here is the Stored Procedure in question:
> ==========================================================
> CREATE OR REPLACE procedure dlc_sp_getStudentInfo (
> studentID IN number,
> studentInfo OUT types.cursorType
> )
>
> as
>
> sFirst varchar2(50);
> sLast varchar2(50);
> sOrient char(1);
>
> begin
>
> open studentInfo for
> select
> sFirst,
> sLast,
> sOrient
> from
> tblStudentInfo
> where
> sid = studentID;
>
> fetch studentInfo into sFirst, sLast, sOrient;
>
> close studentInfo;
>
> end;
> /
> ==========================================================
>
>
> And here is where it is called in my Cold Fusion page:
> ==========================================================
> <cfstoredproc datasource="DLCampus" procedure="dlc_sp_getStudentInfo">
> <cfprocparam type="in" value="#cookieID#" cfsqltype="cf_sql_number">
> <cfprocresult name="getName">
> </cfstoredproc>
> ==========================================================
>
>
> In the database, the table tblStudentInfo is set up as this:
> ==========================================================
> sID number
> sFirst varchar2(50)
> sLast varchar2(50)
> sOrient char(1)
> ==========================================================
>
>
> When I execute the stored procedure by going to the CF page in a
> browser, I get the following error:
> ==========================================================
> Error Executing Database Query.
> [Macromedia][Oracle JDBC Driver]Unsupported data conversion.
> ==========================================================
>
>
> I'm still at a loss, and I can't see what else I can do. Anyone got any
> suggestions?
>
> --
> Richard S. Crawford
> Programmer III,
> UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
> (916)327-7793 / [EMAIL PROTECTED]
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
