Urgent! - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

Urgent!

Urgent!# Java - 爪哇娇娃

r*y2003-10-24 07:10

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.

st2003-10-24 07:10

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*y2003-10-24 07:10

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.

st2003-10-24 07:10

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?