PLSQL object:
- Local Stored Procedure
- Local Functions
- Package
- Package body
- Type
- Type Body
- Anonymous Process
Compilation type
Intermediate interpreted bytecode
LocalC LanguageTarget executableCode(Not applicable to anonymous processes) (efficient, slightly complex)
Compilation options
- Plsql_code_type = "{interpreted | native }"
- Plsql_debug = {true | false}
- Plsql_complier_flags = "{[interpreted | native} [debug | no_debug]}" -- expired
- Plsql_native_library_dir = ospath -- must be created manually
- Plsql_native_library_subdir_count = {0 | n} -- the sub-Folder directory must have a naming rule: D0, D1, d2.... DN; when it is 0, no sub-directory is required.
- Plsql_optmize_level = {0 | 1 | 2} -- optimization level. The higher the level, the higher the compilation cost.
- Plsql_warnings = "{enable | disable | error }: {All | Server | informational | performance | [N,...]},..."
- Plsql_v2_compatibility = {false | ture} -- whether to maintain the special features of 8i
Compilation Method
- There are many ways: the simplest is to use development tools.
- Standard SQL statement: Alter procedure | function .. complie
- Standard package: dbms_complile
