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]
