Stored Procedure - Lengthy SQL - Resources/Ideas

[JonathanHolstin]

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
------------------------------

[david.l.morris]

What do you mean data item limits of 255 characters?

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

[JonathanHolstin]

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
------------------------------