Advertisement
Guest User

Untitled

a guest
Jan 25th, 2020
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. @Override
  2. public String generateCode(BusinessRule br) {
  3. String code = super.generateCode(br);
  4. code += "\nl_aantal pls_integer;"
  5. + "\nBEGIN"
  6. + "\nIF l_oper in ('INS', 'UPD')"
  7. + "\nTHEN"
  8. + "\nSELECT count(*)"
  9. + "\nINTO l_aantal"
  10. + "\nFROM " + br.getTableNameOne()
  11. + "\nWHERE " + br.getTableNameOne() + "." + br.getAttributeNameOne() + " = :new." + br.getAttributeNameTwo() + ";"
  12. + "\nl_passed := l_aantal " + br.getOperator().getValue() + " " + br.getValueList().get(0) + ";"
  13. + "\nIF NOT l_passed"
  14. + "\nTHEN"
  15. + "\nl_error_stack := l_error_stack || '" + "ERROR MESSAGE" + "';"
  16. + "\nEND IF;"
  17. + "\nEND IF;"
  18. + "\nEND;"
  19. + "\nIF l_error_stack is not null"
  20. + "\nTHEN"
  21. + "\nraise_application_error(-20800, l_error_stack);"
  22. + "\nEND IF;"
  23. + "\nEND " + br.getConstraintName() + ";";
  24.  
  25. return code;
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement