| Oracle StoredProcedure returning Object instead of Cursor [message #361160] |
Tue, 25 November 2008 04:22  |
contactanantha
Messages: 3
Registered: November 2008
|
Junior Member |
|
|
Hi,
I have a storedprocedure which should return an object (list of values), i can return a cursor which contains a list of values and cast that into ResultSet in Java class and get the value. But the Cursors are really slow and it fetches the data in a row by row manner , hence is there any way i can return a object without returning Cursor as an OUT parameter in SP to improve the performance? Any suggestions are much appreciated.
Thanks,
OracleCrazy
|
|
|
|
|
|
|
|
| Re: Oracle StoredProcedure returning Object instead of Cursor [message #361393 is a reply to message #361231] |
Wed, 26 November 2008 03:59  |
contactanantha
Messages: 3
Registered: November 2008
|
Junior Member |
|
|
Thanks Guys... I have a couple of doubt,
1) I am planning to get the collection as a VArray. Is there any example to show how to set the list of values in a VArray and return it StoredProcedure.
2) If i am going to return a VArray from StoredProcedure , how i can get the values that are set in the VArray in Java class using the CallableStatement?
Please do let me know your opinions..Thanks in advance.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
