update plsql for batch and test