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

ORA_JAVA.GET_java_type_ARRAY_ELEMENT built-in function

This function returns the current value for a given element in a given array of the specified Java type. The value is returned in its corresponding PL/SQL type.

Syntax


FUNCTION ORA_JAVA.GET_OBJECT_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN ORA_JAVA.JOBJECT;

FUNCTION ORA_JAVA.GET_BYTE_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
   pos IN PLS_INTEGER)
  RETURN PLS_INTEGER;

FUNCTION ORA_JAVA.GET_CHAR_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN PLS_INTEGER;

FUNCTION ORA_JAVA.GET_SHORT_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN PLS_INTEGER;

FUNCTION ORA_JAVA.GET_INT_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN NUMBER;
  
FUNCTION ORA_JAVA.GET_LONG_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN NUMBER;

FUNCTION ORA_JAVA.GET_FLOAT_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN NUMBER;

FUNCTION ORA_JAVA.GET_DOUBLE_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN NUMBER;

FUNCTION ORA_JAVA.GET_STRING_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN VARCHAR2;

FUNCTION ORA_JAVA.GET_BOOLEAN_ARRAY_ELEMENT (
  arr IN ORA_JAVA.JARRAY,
  pos IN PLS_INTEGER)
  RETURN BOOLEAN;
  

Parameters

Description

arr

A valid array of the specified type. The actual parameter is the array of type ORA_JAVA.JARRAY.

pos

Position of the element in the array. Note that the position of the first element is 0. For example, in an array of size 3, the positions of the elements are 0, 1,and 2.

Returns

A value of the corresponding PL/SQL type (PLS_INTEGER, NUMBER, VARCHAR2, BOOLEAN, or ORA_JAVA.JOBJECT).

Usage notes

Example


/*
 ** Example of getting 3 values of an array of data type object.
 */
PROCEDURE get_object_array IS
  arr ORA_JAVA.JARRAY;
  obj1 ORA_JAVA.JOBJECT;
  obj2 ORA_JAVA.JOBJECT;
  obj3 ORA_JAVA.JOBJECT;

BEGIN
  arr := myclass.getMyArray;
  obj1 := ORA_JAVA.GET_OBJECT_ARRAY_ELEMENT(arr, 0);
  obj2 := ORA_JAVA.GET_OBJECT_ARRAY_ELEMENT(arr, 1);
  obj3 := ORA_JAVA.GET_OBJECT_ARRAY_ELEMENT(arr, 2);
  ...
END;

See also

Working with Arrays

ORA_JAVA.NEW_java_type_ARRAY

ORA_JAVA.SET_java_type_ARRAY_ELEMENT