SOLVE: BELOW QUESTION –
Create a package named as INFO which contains procedure that is passed a student’s identification number and return student’s full name and phone number from the student table to the calling program and function, pass a department number to it. If the DEPT table does not contain the department number, return a FALSE value otherwise return a TRUE value. Print the appropriate message to the calling program.
Solve the below problem as soon as possible
Share
CREATE OR REPLACE PACKAGE stu AS
PROCEDURE stu_info(s_id student.id%type);
END stu;
. . . . . . . . . .
THE ANSWER IS IN THE ATTACHMENT TAP ON IT: