Rules tagged with: Stored Object

Stored objects (packages, types, functions, procedures and triggers).

• G-1310Never keep database objects in an invalid state.

  Reliability
• G-7110Try to use named notation when calling program units.

  Maintainability
• G-7120Always add the name of the program unit to its end keyword.

  Maintainability
• G-7125Always use CREATE OR REPLACE instead of CREATE alone.

  Maintainability
• G-7127Always use the FORCE option when creating views.

  Maintainability
• G-7130Always use parameters or pull in definitions rather than referencing external variables in a local program unit.

  Reliability
• G-7140Always ensure that locally defined procedures or functions are referenced.

  Maintainability
• G-7150Try to remove unused parameters.

  Maintainability
• G-7160Always explicitly state parameter mode.

  Reliability
• G-7170Avoid using an IN OUT parameter as IN or OUT only.

  Reliability
• G-7180Try to keep the complexity of functions, procedures and triggers simple.

  Maintainability
• G-7210Try to keep your packages small. Include only few procedures and functions that are used in the same context.

  Reliability
• G-7220Always use forward declaration for private functions and procedures.

  Maintainability
• G-7230Avoid declaring global variables public.

  Reliability
• G-7250Never use RETURN in package initialization block.

  Reliability
• G-7310Avoid standalone procedures – put your procedures in packages.

  Maintainability
• G-7320Avoid using RETURN statements in a PROCEDURE.

  Maintainability
• G-7330Always assign values to OUT parameters.

  Maintainability
• G-7410Avoid standalone functions – put your functions in packages.

  Maintainability
• G-7420Always make the RETURN statement the last statement of your function.

  Maintainability
• G-7430Try to use no more than one RETURN statement within a function.

  Maintainability
• G-7440Never use OUT parameters to return values from a function.

  Maintainability
• G-7450Never return a NULL value from a BOOLEAN function.

  Maintainability
• G-7460Try to define your packaged/standalone function deterministic if appropriate.

  Reliability
• G-7510Always prefix Oracle supplied packages with owner schema name.

  Security
• G-7515Always prefix Oracle supplied object types with owner schema name.

  Security
• G-7520Avoid using deprecated units in your own code.

  Maintainability
• G-7710Avoid cascading triggers.

  Maintainability
• G-7720Never use multiple UPDATE OF in trigger event clause.

  Maintainability
• G-7730Avoid multiple DML events per trigger.

  Reliability
• G-7740Never handle multiple DML events per trigger if primary key is assigned in trigger.

  Reliability
• G-7810Never use SQL inside PL/SQL to read sequence numbers (or SYSDATE).

  Reliability
• G-7910Never use DML within a SQL macro.

  Reliability
• G-9501Never use parameter in string expression of dynamic SQL. Use asserted local variable instead.

  Security

34 total