Solved

Mapping Oracle datatypes to java datatypes

Posted on 2004-04-13
4
370 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …

707 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

13 Experts available now in Live!

Get 1:1 Help Now