> 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 an error telling me that the procresult is
not defined.
>
> On Mon, 2004-03-01 at 16:38, Richard Crawford wrote:
>
>>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]
