I have an Oracle Stored Function written in java. The function returns an ArrayList. I used the following to publish the function:
FUNCTION pull_comments (p_spn NUMBER) RETURN comments_type
AS LANGUAGE JAVA
NAME 'CommentTest.getAllCommentsForSPN(long) return java.util.ArrayList';
Note: comments_type is a REF CURSOR of a tailored RECORD_TYPE.
When I execute the function I receive the following error message:
ORA-00932: inconsistent datatypes: expected OUT Conversion failed
Can you recommend another datatype mapping?