topic RE: Stored Procedure - Lengthy SQL - Resources/Ideas in Product Forum

Stored Procedure - Lengthy SQL - Resources/Ideas

JonathanHolstin — Tue, 31 Dec 2019 13:53:00 GMT

Hello,
I have a sql statement I was attempting to use for an OLEDB connection into Oracle but with data item limits of 255 characters I'm now looking for other ideas. Someone on the RPA Forum said to use a stored procedure. I'm trying to find information on this but it is hard to come by. Does anyone have any good resources for looking into this? If I know sql but no other code is it possible to create a stored procedure?

Thanks,
Jon

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

RE: Stored Procedure - Lengthy SQL - Resources/Ideas

david.l.morris — Tue, 31 Dec 2019 14:45:00 GMT

What do you mean data item limits of 255 characters?

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: Stored Procedure - Lengthy SQL - Resources/Ideas

JonathanHolstin — Tue, 31 Dec 2019 14:51:00 GMT

Hi Dave,
I have a few variable items like PO and segment that I use to create sql statement. I store that in a data item to be used as my sql in OLEDB - Get Collection. I get a character limit of 255 characters when trying to do it this way.

Thanks,

Jon

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