We help IT Professionals succeed at work.

Mapping Oracle datatypes to java datatypes

bjgardner
bjgardner asked
on
Medium Priority
477 Views
Last Modified: 2008-02-01
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?
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010

Commented:
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.