1 | Performance: tends to execute faster than regular SQL code becuse it doesn't need to be parsed and interpreted before executing |
2 | Portable across all Oracle platforms: resides completely inside the database thus is 100% portable to any platform that Oracle7 runs on |
3 | Modularity: has procedure,package etc mechanisms for software development in modules |
4 | Why not? Not portable to other databases! |