Tell Me Glossary
 

7.2 Review Code

Previous previous|next Next Page

When reviewing code, first identify all dynamic SQL statements. Here are some key indicators that dynamic SQL is in use:

  • EXECUTE IMMEDIATE
  • OPEN cursor_var FOR ...
  • DBMS_SQL
  • DBMS_SYS_SQL

Next, check to make sure that bind arguments are used in all possible and practical instances. Where bind arguments cannot be used, make sure that the correct routines are used to filter and sanitize inputs.

Use this code review checklist for guidance.