OLEDB - SQL Query - Too many characters - Data Item

[JonathanHolstin]

Hello,
I need to run a large sql statement.  Currently the only way I know how to pass sql into the Data - OLEDB (Get Collection) is by using a data item with the sql statement.  That limits you to a small number of characters (255?).  Does anyone know how to pass a large sql statement into the Get Collection action?

Thanks!
Jon

------------------------------
Jonathan Holstine
Systems Accountant
Interior Business Center
America/Denver
------------------------------

[VivekGoel]

There is no such limitation.
Can you post the SQL Please?

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

[EdGarabedian1]

Hi Jonathan,
I recently ran into this as well working with OLEDB.  One method would be to use multiple data items for sections and then concatenate in a final data item, i.e.  [sql pt1] & [sql pt2].  I created variables for the base sql, where clause, and fields I would select and then concatenated together for complete sql statement. Another method would be to store the query in an external text file, load that file when needed and pass to object. You could do this with the pre-built Utility-File Management VBO or you could use a code stage, example here: http://portal.blueprism.com/customer-support/support-center#/path/1158159412
Thanks,
Ed

------------------------------
Ed Garabedian
Sr. Solutions Consultant
Blue Prism
------------------------------