r******y
发帖数: 7 | 1 I want to pass a array of strings in java program to a stored procedure as parameter? Are there some one who have such kind of development experience?
I will appreciate it of some one can share some experience with me.
Thanks for your attention and have a nice weekend. |
st
发帖数: 1685 | 2 what kind of array? what database? I think with oracle, you cna easily do it.
【在 r******y 的大作中提到】
: I want to pass a array of strings in java program to a stored procedure as parameter? Are there some one who have such kind of development experience?
: I will appreciate it of some one can share some experience with me.
: Thanks for your attention and have a nice weekend.
|
r******y
发帖数: 7 | 3 Array of string need to be passed to oracle stored procedure.
Could you kindly give me some instructions or sample on this issue.
Thanks a lot.
it.
as parameter? Are there some one who have such kind of development experience?
【在 st 的大作中提到】
: what kind of array? what database? I think with oracle, you cna easily do it.
|
st
发帖数: 1685 | 4 http://www.princeton.edu/~storacle/jdbc8_doc/oracle.sql.ARRAY.html
how about this one? we dont use oracle any more, but we migrate from it,
so I saw old code using this.
static public void preArray( CallableStatement call,int index,
java.sql.Array initVal ) throws java.sql.SQLException
{
if( initVal == null )
call.setNull( index, java.sql.Types.ARRAY );
else
call.setArray( index, initVal );
}
that's basically it. as
【在 r******y 的大作中提到】
: Array of string need to be passed to oracle stored procedure.
: Could you kindly give me some instructions or sample on this issue.
: Thanks a lot.
:
: it.
: as parameter? Are there some one who have such kind of development experience?
|
