UsePL-SQL to create a package, Student_Course, in the Oracle SQL Developer. The package contains a stored procedure namedSelectStudentCourse() with two positional parameters,

a. The input student name, studentName, with VARCHAR2 data type.

b. The output cursor, StudentCourse, containing all course_id values selected by that student.

Two queries are involved in this stored procedure; the first one is used to query the student_id from the Student Table based on the input student name, and the second is to query all course_id values taken by the selected student from the StudentCourse Table based on the student_id retrieved from the first query.

Compile and run this package after it is created to confirm that it works.