Question

CREATE TABLE DEPT (DEPT_ID INT(2), DNAME VARCHAR(14), LOC VARCHAR(15), DATE_INSERTED DATE, DATE_LASTUPDATED DATE, PRIMARY KEY(DEPT_ID)); CREATE TABLE SALGRADE (GRADE_ID INT(3), LOSAL NUMERIC
(7,2)
, HISAL NUMERIC
(7,2)
, PRIMARY KEY(GRADE_ID)); CREATE TABLE EMP (EMP_ID INT(4), E_LAST_NAME VARCHAR(20), E_FIRST_NAME VARCHAR(15), JOB VARCHAR(9), MGR_ID INT(4), HIREDATE DATE, SAL NUMERIC(7,2), GRADE_ID INT(3), COMM NUMERIC
(7,2)
, DEPT_ID INT(2), DATE_INSERTED DATE, DATE_LASTUPDATED DATE, PRIMARY KEY(EMP_ID), FOREIGN KEY (DEPT_ID) REFERENCES DEPT(DEPT_ID), FOREIGN KEY (GRADE_ID) REFERENCES SALGRADE(GRADE_ID)); Create a procedure that has one input parameter a value for MGR_ID, and an out parameter to return the employee id with the oldest hire date for that manager (so the most senior employee that reports to that manager). You will have to do a little research on the output parameter and how to use it.

Answer 1

The parameters that are retrieved from a service call's response are known as output parameters. Before being displayed on the device, these are prepared in accordance with the attributes you set for the output.

A scope and data type are associated with the service parameters. You must provide the scope and the data type when defining a service's input and output parameters. Output Parameters are defined using the following characteristics:

ID: This value can only be accessed by using this name, which is unique.

Xpath - Xpath is used to retrieve the necessary components from the service request response. An XML document's elements and attributes can be explored using XPath. Visit http://www.w3schools.com/xpath/ for additional details about XPath.

To know more about output parameters, visit;

brainly.com/question/15171199

#SPJ4