Pass String Array as input to Java Stored Procedure [Archive]

View Full Version : Pass String Array as input to Java Stored Procedure

lenin_s

03-01-2006, 07:15

Hi,
Could you please help sort out my issue with JDBC data types. I have a requirement wherein i need to pass a string array (java.lang.String[]) to a stored procedure as input. The data type java.lang.String[] is not directly supported. Could you please suggest an alternative mechanism?

Best Regards
Sivaraj Lenin

mcarlson

03-01-2006, 07:18

How is this variable defined in your stored procedure? What DBMS are you using?

Mark

lenin_s

03-01-2006, 07:28

Hi
Thanks for your quick reply. Please find attached the java stored procedure code. In my flow service, I've a string list variable. I've set the input type as java.lang.Object for the JDBC adapter service which invokes this stored procedure. Please advise.

Cheers