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.
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. |
A value of the corresponding PL/SQL type (PLS_INTEGER, NUMBER, VARCHAR2, BOOLEAN, or ORA_JAVA.JOBJECT).
/*
** 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;
ORA_JAVA.SET_java_type_ARRAY_ELEMENT