Advertisement

10.06.2008 at 09:48AM PDT, ID: 23791040 | Points: 500
[x]
Attachment Details

spring 2.0 pass list of object/string to stored procedure in oracle

Asked by wxII in XPath, PL / SQL, Oracle 11.x Database

Tags: , , , , ,

hi experts,

how do i pass a list<String> into oracle's stored procedure using Spring2.0 framework? in oracle stored program, there are few collections which is varray,nested tables and associative array, which is the most resembled to list in java? nested table perhaps? i can pass normal single scalar values for IN parameters of stored program but not sure about list. and don't know whether can use OracleTypes.ARRAY or not. please advise. thanks

wesleyStart Free Trial
 
Keywords: spring 2.0 pass list of object/string…
Title
1 Extract Contents Of Varray with SQL
2 Problems returning an VARRAy from a …
3 oracle varrays
4 Spring JDBC - Oracle Query issue (…
5 Oracle SQL varray
6 VARRAY within a VARRAY
 
Loading Advertisement...
 
[+][-]10.06.2008 at 10:08AM PDT, ID: 22652112

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.07.2008 at 09:37PM PDT, ID: 22666196

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-44 / EE_QW_2_20070628