Is it possible to define package procedure/function outsize of package body block (for Oracle)?
Simplified syntax for defining package body is:
create or replace package body <package_name> IS function <function_name> <function_body> procedure <procedure_name> <procedure_body> end <package_name>; /
Is it possible to define procedure within package like:
procedure <package_name>.<procedure_name> <procedure_body>
I ask this question as I am newbie and don't understand why I need to compile whole package when I need only to apply changes form a single procedure...
- What are the benefits of packages over standalone procedures and functions?
Always use a package. Never use a standalone procedure except for demos, tests and standalone utilities (that call nothing and are called by nothing)