I have a complex sql that completes but does not bring any data back. I have pulled data from each view individually. I'm wondering if BP - does not like selects within selects within selects. This exact sql runs and pulls data in sql developer. Anyone have experience with this or any...
I'm trying to pull a simple ---
Select * From [Excel Sheet]
Could not execute code stage because exception thrown by code stage: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
I'm trying to use various versions of the following statement. With [Excel...
I have a collection which has 500 rows and want to update this data in to a table in sql . I was aware I can update row by row by looping each one is there a way I can update all the data in the collection in one go from Blue prism Process to sql table?
If it is calling
I am unable to call stored procedure using Blue Prism , I am able to set connection to the DB and also able to run a query using "get collection" action in OLE DB VBO.
Can anyone please suggest the format for stored procedure call and how to pass parameters.
I've created a process that take data from a database and create a collection like that in fig1.
This data must by taken from Outlook for send emails to those recipients and remind them that the activities must be completed within a certain date.
The process works fine, but Outlook send one...