Write PL/SQL procedures to accomplish the following tasks. Test and show the procedures and triggers work. Capture output in spool showing the operations. For procedures, obtain the relevant value from the user in a variable name, then pass it on to the procedure and execute it. Keep the name of this user input variable distinct from the ones you used in the procedure. Make each trigger work and show how you verified it.

Write a procedure that retrieves the order date, customer number, and name based on the order number. Use I_ORDER_NUM as input parameter and place the values in the variables I_ORDER_DATE, I_CUSTOMER_NUM,I_CUSTOMER_NAME, respectively. Output the contents of I_ORDER_DATE, I_CUSTOMER_NUM, and I_CUSTOMER_NAME.