Search Results get_nth_native_compiler_option




Overview

SYS.DBMS_JAVA_DEFINERS is an internal Oracle-supplied PL/SQL package body that acts as the PL/SQL-to-Java bridge for the Oracle Aurora (JServer) native Java compilation infrastructure. Its business function within Oracle E-Business Suite 12.1.1 and 12.2.2 is not transactional; rather, it exposes Java stored procedures that allow the database to compile Java classes and methods to native machine code (ahead-of-time, or AOT, compilation) and to manage the compiler options that govern that process. The package is classified as OTHER in the ETRM registry, confirming that it is a system-level utility rather than a documented EBS business API. It is owned by SYS and is referenced by one other package, indicating a narrow, specialised role inside the Java runtime layer.

Key Procedures and Functions

The package documents eight program units, all declared with the language java name clause, meaning each maps directly to an underlying Java method in the oracle.aurora.zephyr namespace.

  • GET_NTH_NATIVE_COMPILER_OPTION — Returns a description of the compiler option at a given ordinal position, backed by CompilerOptions.describeOption. This is the entry point most users encounter, because it lets callers enumerate the native compiler options available in the database.
  • SET_NATIVE_COMPILER_OPTION_ — Sets a named native compiler option to a supplied value for a specified owner. Maps to CompilerOptions.setCompilerOption.
  • DECODE_NATIVE_COMPILER_OPTION_ — Resolves or interprets a compiler option name/value pair, mapping to CompilerOptions.decodeCompilerOption.
  • UNSET_NATIVE_COMPILER_OPTION_ — Removes a previously set compiler option for the given owner, mapping to CompilerOptions.unsetCompilerOption.
  • COMPILE_CLASS_ — Compiles an entire Java class natively for the specified schema and class name via AOTDriver.compileClass.
  • COMPILE_METHOD_ — Compiles a single Java method natively, identified by schema, class name, method name, and method signature, via AOTDriver.compileMethod.
  • UNCOMPILE_CLASS_ — Reverses native compilation for a class, with a permanence flag, via AOTDriver.uncompileClass.
  • UNCOMPILE_METHOD_ — Reverses native compilation for an individual method, again with a permanence flag, via AOTDriver.uncompileMethod.

The trailing underscores on most names denote private helper routines intended for internal use; the primary documented public access is available through related dictionary views and the DBMS_JAVA interface.

Tables Accessed

No base tables are documented as referenced through APPS synonyms for this package. The underlying Java routines manipulate JServer metadata held in the Aurora/Java data dictionary (such as the Java class and compiler-option repositories), and the option routines persist compiler settings associated with an owner identifier. Direct SQL access to those internal structures is not exposed through EBS application synonyms.

Usage Notes

This package is invoked indirectly rather than called from EBS forms or concurrent programs. In practice it supports native Java compilation performed with DBMS_JAVA procedures (for example, DBMS_JAVA.COMPILE_CLASS and related native-compilation entry points), which administrators use to accelerate the performance of Java stored procedures in the EBS database tier. The search term "get_nth_native_compiler_option" corresponds to the enumeration helper used to discover which ojvm/native compiler options exist before setting them. Custom code should not call these routines directly, as they are SYS-owned internals subject to change between releases; the supported route is through DBMS_JAVA and its documented wrapper procedures.