posted 17 years ago
Arrays can be used in Stored Procedures . Oracle has a data type VARRAY that supports this .
Whole flow of usage is :-
-Define/Create a VARRAY of any primitive data type like integers/varchar2 in ORACLE .
-Use this VARRAY type as a INOUT type in the signature of SP .
-Set the Array type through any Statement object in JDBC .
-Manipulate this ARRAY in SP .
-Get the ARRAY back .
VARRAY is supported in ORACLE . DB2/Sybase have temp tables . SQL Server not sure