
Build a package
EMPPACK that contains one stored function Validatesal() and two stored
procedures Insertemp() and Getempdetails().The Insert_emp() procedure
inserts a particular employee tuple into the EMP table if salary of the employee
lies between 2000 and 50000 checked by the Validate_sal() function.
Otherwise it throws an exception with an error message -?Salary Out of
range?.The Getemp_deails() then displays the empid,ename and sal values of the
newly inserted employee record.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
