Solved

Mapping Oracle datatypes to java datatypes

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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Apps blocked by Java 9 79
table example 4 29
arguments to jar 5 26
eclipse apache tomcat admin console 52 97
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
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…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:

777 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