>
>
> 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>
> ==========================================================
One thing I noticed is your calling code referenced the procedure directly. I think you need to create a package spec and have the cfstoredproc point to the name of the spec. In the header is where you create a ref cursor and you don't need the return type if the ref cursor is unrestrictive type.
CREATE OR REPLACE PACKAGE pkg_studentInfo
AS
TYPE studentInfo REF CURSOR;
PROCEDURE dlc_sp_getStudentInfo (
studentID IN number,
arg_cursor OUT types.studentInfo
);
END pkg_studentInfo;
=========================================================
THEN YOU GO ON AND CREATE THE PACKAGE BODY WHICH INCLUDES THE "dlc_sp_getStudentInfo" PROCEDURE.
=========================================================
Nick Han
>>> [EMAIL PROTECTED] 03/02/04 10:10AM >>>
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 gives an error telling me that the procresult is
>>not defined.
>
>
> I mean you are selecting varchar2 and char in your refcursor have you
> just tried one or the other to see if it has a problem with just one of
> those datatypes - it's probably a conversion between what the drive says
> is a query and what cf thinks is a query, but I was hoping the
> Unsupported data conversion was refering to one of the column types.
>
Hm. I tried with varchar2(50) at each point, and with char(50) at each
point. Both gave me the same error.
--
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]
