I have a question regarding "Execute Stored Procedure" plug-in. I have

samuelr over 11 years ago

I have a question regarding "Execute Stored Procedure" plug-in. I have a stored procedure that needs to insert rows into the database. If I was calling it from java I would either use addBatch on the CallableStatement or pass in arguments of type Types.ARRAY and have the procedure loop through the entries. I have tried passing an array or a field with multiple enabled into the procedure using the "Execute Stored Procedure". However, this did not work. Is there any way to use this plug-in to pass several rows worth of information into the stored procedure withough calling the plug-in over and over again, which is very slow....

Discussion posts and replies are publicly visible

Parents

0 Jason Ruvinsky
Certified Senior Developer
over 10 years ago

We are passing arrays into stored procedures by first converting the array into a string with a delimiter (we use "~" since that is unlikely to be a character used in the data). Then the stored procedure parses this string back into an array.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jason Ruvinsky
Certified Senior Developer
over 10 years ago

We are passing arrays into stored procedures by first converting the array into a string with a delimiter (we use "~" since that is unlikely to be a character used in the data). Then the stored procedure parses this string back into an array.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data