I have to write stored procedure which returns resultset.I have two tables Student and StudentAttendance. In studentAttendance table weekwise ,each students data like actualattendedsession, absence and other details are stored.
To the stored procedure i would be passing input as No.ofweeks, recordstofetch and schoolid. Maximum no. of weeks will be 15.
I have declared object of TYPE with fields as studentId, Field1, Field2...Field15.(Field1 correspond to week1..)
My problem is how do i return For one studentId, for all weeks differentData.
How do I declare TYPE OBJEct ?