?
Solved

Mapping Oracle datatypes to java datatypes

Posted on 2004-04-13
4
Medium Priority
?
419 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 14

Accepted Solution

by:
Tommy Braas earned 2000 total points
ID: 10815673
java.util.Vector
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses
Course of the Month9 days, 17 hours left to enroll

762 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