Question: The Nav bar doesnt go to the top of the screen when rounding the edges on iphone x or up. Is there any way to fix this?

[IMAGE(WHAT IT LOOKS LIKE NOW)](https://i.stack.imgur.com/lXuT1.png)

```
import UIKit

class ViewController: UIViewController {

    override func viewDidLoad() {
        super.viewDidLoad()

        self.navigationController?.navigationBar.layer.cornerRadius = 20
        self.navigationController?.navigationBar.clipsToBounds = true
        self.navigationController?.navigationBar.layer.maskedCorners = [.layerMinXMaxYCorner, .layerMaxXMaxYCorner]
    }

}

```

Answer: 
Because there's no `ID` column, but `passengerId` within the Reservations table :

```
CREATE OR REPLACE Procedure InsertNewReservation
                           ( 
                            flight_number Reservations.flightNumber%type,
                            passenger_id  Reservations.passengerId%type,
                            flight_price  Payments.value%type 
                           )
IS
   s2 Payments.reservationId%type;
BEGIN
   insert into Reservations (flightNumber,passengerId) 
   values(flight_number,passenger_id) returning passengerId into s2;

   insert into Payments (value,reservationId) Values (flight_price,s2);
END;
/

```

btw, replace the variables so as to conform their respective types within the table, and using `IN` operator is redundant for parameter type of the procedure as being the default.

`[Demo](https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=df02071ff3eeaed865f5c990d26957af)`
Remove the `exec` keyword, which is not used in a PL/SQL block:

```
begin
  InsertNewReservation('FL100',1,120);
end;

```

`exec` is used in tools like SQL Plus to run a procedure outside a PL/SQL block:

```
SQL> exec InsertNewReservation('FL100',1,120);

```