A script-enabled browser is required for this page to function properly.

ORA_JAVA built-in package

Procedure/Exception/Function

Description

ORA_JAVA.NEW_GLOBAL_REF

function that returns a reference handle that can be used as a global variable to reference an object of type ORA_JAVA.JOBJECT

ORA_JAVA.DELETE_GLOBAL_REF

procedure that deletes the global reference object that was created by ORA_JAVA.NEW_GLOBAL_REF

ORA_JAVA.LAST_EXCEPTION

function that returns the last Java exception that occurred when calling Java from PL/SQL

ORA_JAVA.CLEAR_EXCEPTION

procedure removes the last exception retrieved by ORA_JAVA.LAST_EXCEPTION

ORA_JAVA.LAST_ERROR

function that returns the error text of the last PL/SQL exception that occurred when calling Java from PL/SQL

ORA_JAVA.CLEAR_ERROR

procedure removes the last error text retrieved by ORA_JAVA.LAST_ERROR

ORA_JAVA.NEW_java_type_ARRAY, which includes:

  • NEW_OBJECT_ARRAY
  • NEW_BYTE_ARRAY
  • NEW_CHAR_ARRAY
  • NEW_SHORT_ARRAY
  • NEW_INT_ARRAY
  • NEW_LONG_ARRAY
  • NEW_FLOAT_ARRAY
  • NEW_DOUBLE_ARRAY
  • NEW_STRING_ARRAY
  • NEW_BOOLEAN_ARRAY

function that creates a new array of the specified Java type

ORA_JAVA.IS_NULL

function that returns a BOOLEAN value that indicates whether or not an object is null

ORA_JAVA.GET_ARRAY_LENGTH

function that returns the size (length) of an array

ORA_JAVA.GET_java_type_ARRAY_ELEMENT, which includes:

  • GET_OBJECT_ARRAY_ELEMENT
  • GET_BYTE_ARRAY_ELEMENT
  • GET_CHAR_ARRAY_ELEMENT
  • GET_SHORT_ARRAY_ELEMENT
  • GET_INT_ARRAY_ELEMENT
  • GET_LONG_ARRAY_ELEMENT
  • GET_FLOAT_ARRAY_ELEMENT
  • GET_DOUBLE_ARRAY_ELEMENT
  • GET_STRING_ARRAY_ELEMENT
  • GET_BOOLEAN_ARRAY_ELEMENT

function that returns the current value for a given element in a given array of the specified Java type

ORA_JAVA.SET_java_type_ARRAY_ELEMENT, which includes:

  • SET_OBJECT_ARRAY_ELEMENT
  • SET_BYTE_ARRAY_ELEMENT
  • SET_CHAR_ARRAY_ELEMENT
  • SET_SHORT_ARRAY_ELEMENT
  • SET_INT_ARRAY_ELEMENT
  • SET_LONG_ARRAY_ELEMENT
  • SET_FLOAT_ARRAY_ELEMENT
  • SET_DOUBLE_ARRAY_ELEMENT
  • SET_STRING_ARRAY_ELEMENT
  • SET_BOOLEAN_ARRAY_ELEMENT

procedure that changes the value of a given element in a given array of the specified Java type to a given value

See also

About the ORA_JAVA built-in package

About built-in packages