A PL/SQL procedure which assigns a ticket to a support staff. The procedure takes a ticket ID and a staff ID as input and does the following steps. 

1) it checks whether there is a ticket with the given ticket ID. If not print a message invalid ticket ID and stops. 

2) it then checks whether a support staff has the input staff ID. If not print a message invalid staff ID and stop. 

3) it assigns the ticket to the support staff (update the sid in ticket table), update status to 2, and insert a row into ticket_detail with appropriate tkid, sid, tdtime as current time (systimestamp), and content as 'ticket assigned to support staff'.

 

Please call this procedure with an invalid input and a valid input. 

Answer rating: 100% (QA)

Solution Here is a PLSQL procedure that assigns a ticket to a support staff performing the necessary ... View the full answer