Return 2 values (string, number) multiple rows, from java stored function



I would like to return 2 values (String, number prefered but String,
String will work) from a java stored function.

I was able to successfully return a varray of varchar2 values but I was
wondering if it is possible to return 2 values by using a varray?

Is it even possible? I tried using combinations of types which included
a varray of objects (with 2 attributes) or a type as table of objects
but I couldn't figure out how in my java code to set these values. Also
what would my java function return type be and what Oracle type would
map to it?

Any help and examples or pointers would be great.

Thanks,
Dennis

.



Relevant Pages

  • Re: Help me!! Why java is so popular
    ... String or StringBuffer? ... keep in mind I knew NOTHING about Java. ... The language accepted it, no warnings, and thus I ... in some native assemblers you can peruse the instruction ...
    (comp.lang.java.programmer)
  • Re: question about assigning null to a reference object
    ... String getAuthor() ... void setAuthor ... b.setTitle("Thinking in Java 4th Edition"); ...
    (comp.lang.java.help)
  • Re: Java questions: Urgent
    ... why I would expect almost any Java programmer to be able to answer ... Which is the main reason I "butted" in a bit.. ... on the characters in the String. ... > therefore naturally cover all the basics, or they have missed out badly ...
    (comp.lang.java.programmer)
  • Re: A C++ Whishlist
    ... with the C++ string classes as compared with the Java ones. ... You can keep you structs entirely ... The simple separation of interface and implementation that header files ...
    (comp.lang.cpp)
  • Re: Using Cobol when writing CGIs for the OSU web server.
    ... string safe as well as make slow conversion (as bugs are found and ... The string type approach. ... Because no one has bothered to add it to the "offending" language. ... Java is certainly no replacement for C. ...
    (comp.os.vms)