... OR REPLACE PROCEDURE sp_get_studentdetails_from_ad (
p_STUDENT_ADNAME IN varchar2,
l_CURSOR OUT sys_refcursor
)
IS
BEGIN
-- going to declare variables that are to be returned in SSRS ...
... (
c_test out sys_refcursor,
p_STUDENT_ADNAME in varchar2
)
IS
BEGIN
OPEN c_test FOR
SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME;
END;
View the results? ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.