Need to use more than 32 parameters in the workbench

[Former Member]

When using the workbench, we have reached the maximum number of parameters (32) but my database Iu2019m inserting into has more than 32 fields. Is there a way to work with more than 32 parameters? Currently I have to insert the first 32 parameters and then perform an update query for the remaining parameters.

We are using MII version 12.0.

Thanks

George

[Former Member · Accepted solution]

Just build a string of your values and assign them to one parameter

"'" & Local.param1 & "', '"  & Local.param2 & "', '"  & etc...

[salvatore_castro]

George,

The 32 parameter limitation is there on purpose in the product in order to prevent people from abusing parameters and creating unmanagable queries. In your case you have a valid reason so we will consider modifying this as a result be it's a far and few between case. I suggest following Christian's suggestion and building the query inputs ahead of time and then pass in the string.

Maybe in the future we will support more but not anytime soon, so you'll have to use a workaround for now.

Regards,

Sam

[salvatore_castro]

George,

The 32 parameter limitation is there on purpose in the product in order to prevent people from abusing parameters and creating unmanagable queries. In your case you have a valid reason so we will consider modifying this as a result be it's a far and few between case. I suggest following Christian's suggestion and building the query inputs ahead of time and then pass in the string.

Maybe in the future we will support more but not anytime soon, so you'll have to use a workaround for now.

Regards,

Sam

[Former Member]

George,

if you are working with Oracle DB, you may have a look at the XSU (XML SQL Utility):

[XSU for PL/SQL|http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96621/adx23xsp.htm]

You can build a XML with all your insert / update / delete rows, and call a stored procedure that calls the XSU interface. This is quite fast (only one DB call) and you can use as many parameters as you need.

Michael

[Former Member]

George,

You can group multiple related parameters and build xml data structure. This data structure can go as a single parameter. the xml can be decoded again after passing. Thus you can send more than 32 parameters.

BR,

SB