Create or Replace Procedure Cust_Reservation(p_ID IN VARCHAR2) AS
2 CURSOR c_viewreservation IS
3 SELECT Consumer.FirstName,Consumer.LastName,Restaurant.Na me,Restaurant.Type,Reservation.ReservationDateTime ,Consumer.ConsumerID FROM(Consumer INNER JOIN Reservation ON Consumer.ConsumerID = Reservation.ConsumerID)INNER JOIN Restaurant ON Reservation.RestaurantID = Restaurant.RestaurantID WHERE ConsumerID = p_ID;
4 v_viewreservation c_viewreservation%ROWTYPE;
5 BEGIN
6 OPEN c_viewreservation;
7 FETCH c_viewreservation INTO v_viewreservation;
8 WHILE c_viewreservation%FOUND LOOP
9 DBMA_OUTPUT.PUT_LINE(v_viewreservation.FirstName|| ' '||v_viewreservation.LastName||' '||v_viewreservation.Name||' '||v_viewreservation.Type||' '||v_viewreservation.ReservationDateTime);
10 FETCH c_viewreservation INTO v_viewreservation;
11 END LOOP;
12 CLOSE c_viewreservation;
13 END Cust_Reservation;
14 /

Warning: Procedure created with compilation errors.

SQL> show error
Errors for PROCEDURE CUST_RESERVATION:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/8 PLS-00341: declaration of cursor 'C_VIEWRESERVATION' is
incomplete or malformed

3/2 PL/SQL: SQL Statement ignored
3/318 PL/SQL: ORA-00918: column ambiguously defined
4/20 PL/SQL: Item ignored
7/2 PL/SQL: SQL Statement ignored
7/31 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

9/3 PL/SQL: Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
9/24 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

10/1 PL/SQL: SQL Statement ignored
10/30 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

Try executing the SELECT statement (defined as part of the cursor definition) independently and check if it results in any error.

Also it looks like there is a space between Restaurant.Na and me.