... 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? ...
... exception_section]
END [function_name];
Example: My example accepts an Active Directory (AD) username and returns the student ID:
CREATE OR REPLACE FUNCTION fn_get_sref_from_adname
...
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.