Home > Archive > Java Databases > September 2005 > Return 2 values (string, number) multiple rows, from java stored function
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Return 2 values (string, number) multiple rows, from java stored function
|
|
| dennis 2005-09-26, 6:56 pm |
| 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
|
|
|
|
|