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 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
> > 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 package body schemaname.studentpackage
> > IS
> >
> > PROCEDURE test_dlc_sp_getStudentInfo (
> > studentID IN number, student_cursor IN OUT student_type_ref_cursor)
> > is
> > begin
> > open student_cursor
> > for
> > select sFirst, sLast, sOrient
> > from tblStudentInfo
> > where sid = studentID;
> > end;
> >
> > END studentpackage;
> >
> >
> >
> >
>
>----------
>[
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
