more detailed logging and notnull fix for oracle