Rules tagged with: Stored Object

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

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

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

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

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

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

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

  Maintainability
• G-7150 Try to remove unused parameters.

  Maintainability
• G-7160 Always explicitly state parameter mode.

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

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

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

  Maintainability
• G-7230 Avoid declaring global variables public.

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

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

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

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

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

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

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

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

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

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

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

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

  Maintainability
• G-7710 Avoid cascading triggers.

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

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

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

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

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

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

  Security

31 total