Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Override
- public String generateCode(BusinessRule br) {
- String code = super.generateCode(br);
- code += "\nl_aantal pls_integer;"
- + "\nBEGIN"
- + "\nIF l_oper in ('INS', 'UPD')"
- + "\nTHEN"
- + "\nSELECT count(*)"
- + "\nINTO l_aantal"
- + "\nFROM " + br.getTableNameOne()
- + "\nWHERE " + br.getTableNameOne() + "." + br.getAttributeNameOne() + " = :new." + br.getAttributeNameTwo() + ";"
- + "\nl_passed := l_aantal " + br.getOperator().getValue() + " " + br.getValueList().get(0) + ";"
- + "\nIF NOT l_passed"
- + "\nTHEN"
- + "\nl_error_stack := l_error_stack || '" + "ERROR MESSAGE" + "';"
- + "\nEND IF;"
- + "\nEND IF;"
- + "\nEND;"
- + "\nIF l_error_stack is not null"
- + "\nTHEN"
- + "\nraise_application_error(-20800, l_error_stack);"
- + "\nEND IF;"
- + "\nEND " + br.getConstraintName() + ";";
- return code;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement