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]
