Solved

Mapping Oracle datatypes to java datatypes

Posted on 2004-04-13
4
382 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?
0
Comment
Question by:bjgardner
4 Comments
 
LVL 14

Accepted Solution

by:
Tommy Braas earned 500 total points
ID: 10815673
java.util.Vector
0
 
LVL 92

Expert Comment

by:objects
ID: 10817773
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Understanding websocket example in spring 1 57
maven example error 3 52
micro services spring boot application error 3 146
reverse digits of a number using for loop 5 36
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now