• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Passing a string array as a parameter - urgent

 
Subrahmanyam Devarakonda
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Saloon Keeper
Posts: 3890
15
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you tried setArray() in the PreparedStatement API?
 
Subrahmanyam Devarakonda
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot. We are trying it out.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic