CREATE OR REPLACE PROCEDURE cancelTicket2(bkingid IN NUMBER)
    IS

cnt NUMBER;
loc booking.location%TYPE;
permission_denied EXCEPTION;

BEGIN
    SELECT location INTO loc FROM booking WHERE bid = bkingid;
    IF loc = 'Sylhet'
            THEN
                UPDATE booking SET booking_status = 'Canceled' WHERE bid = bkingid;
        COMMIT;

        SELECT count_ INTO cnt FROM ticket
            WHERE ticketid =
                (SELECT ticketid FROM booking WHERE bid = bkingid);

        IF cnt = 1
            THEN
                UPDATE ticket SET status_ = 'available' WHERE
                    ticketid =
                    (SELECT ticketid FROM booking WHERE bid = bkingid);
        END IF;
        COMMIT;
        RETURN 'Canceled';
    ELSIF loc = 'Dhaka'
            THEN RAISE permission_denied ;
    END IF;
EXCEPTION
    WHEN permission_denied THEN DBMS_OUTPUT.put_line("You don't have the permission");
END;
/