Passing a string array as a parameter - urgent

[Subrahmanyam Devarakonda]

Hi,

We have a stored procedure which takes a synonym as its input parameter.

A friend of mine told me pass String[] to your callable statement as a parameter.

My post is

1. How to pass a String[] as a parameter to a procedure call?

2. Is there any alternative way to pass values to such a procedure which takes a synonym as a input parameter?

Thanks in advance.

[Scott Selikoff]

Have you tried setArray() in the PreparedStatement API?

[Subrahmanyam Devarakonda]

Thanks a lot. We are trying it out.