ORA_JAVA.GET_java_type_ARRAY_ELEMENT
built-in functionThis 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 |
|
A valid array of the specified type. The actual
parameter is the array of type |
|
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
).
ORA_JAVA.GET_ARRAY_LENGTH
to determine the size of the array first.
/*
** 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
Copyright © 1984, 2005, Oracle. All rights reserved.