Pass String Array as input to Java Stored Procedure

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

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


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.