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