Objects should not be duplicated (same name and same type)


    The Pl_Sql code rule "Objects should not be duplicated (same name and same type)" means that objects within a Pl_Sql program should not have the same name and same type. This is because having multiple objects with the same name and type can lead to confusion and errors in the program. It is important to ensure that each object has a unique name and type to avoid any potential issues.

Key Benefits

  • Reduced complexity: Objects with the different name and type can be easily identified and managed, reducing the complexity of the system.
  • Easier debugging: Duplicate objects can cause confusion and errors, making debugging more difficult. By avoiding duplication, debugging is made simpler.
  • Improved performance: Duplicate objects can lead to unnecessary memory usage and slower performance. By avoiding duplication, performance can be improved.


Visual Expert 2024