Using the Colonial Adventure Tours Database from A Guide To SQL (9th Edition), Write a stored procedure in PL/SQL to retrieve and output the reservation id, trip id, number of persons and trip price for every reservation made by a particular customer based on the customer number supplied.

Schema:

?eject Browser ? 127.0.0.1:8080/apex/f?p-4500:1001 :3654456629742387-NO::: ORACLE Application Express Welkome COLONIAL ADVENTURE Logout Application Builder? SQL Workshop Hame S0L Workshop Object Browser Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS HTMLDE PLAN TABLE RESLRVATION TRIP_GUIDES Appication Lxpress 4.0 2.00.09 Wolapac COLONIAL ADVENTURE Uaer COLONIAL ADVENTURF Language en Copynght &1330, 2010, Crade All rihts eserved