changed boolean so it can be used in oracle