... 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? ...
... (ad_username IN varchar2)
RETURN number
IS
student_no number;
cursor c1 is
select student_reference
from student_accounts_table
where student_ad_account = trim(lower(ad_username));
BEGIN
...
... Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID ...
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.