Hi Devart Team,
How could I extract instance specific information from BLOB fields in Oracle Workflow Instance Store?
Could you show an example please?
Thanks!
Workflow Instance Store
Re: Workflow Instance Store
By the way, looks like DB diagram at the WF Tracking documentation page is out of date as you have DATA_ID in WF_CUSTOM_TRACKING_RECORD now.
Re: Workflow Instance Store
The Devart implementation of Oracle Workflow Instance Store is described at https://www.devart.com/dotconnect/oracl ... Store.html.
Could you please describe your scenario? Why do you need to read BLOB fields manually? Anyway, you can read data from database with OracleDataReader: https://www.devart.com/dotconnect/oracl ... eader.html.Partizan wrote:How could I extract instance specific information from BLOB fields in Oracle Workflow Instance Store?
Could you show an example please?
Thank you for your report. We will correct our documentation.Partizan wrote:By the way, looks like DB diagram at the WF Tracking documentation page is out of date as you have DATA_ID in WF_CUSTOM_TRACKING_RECORD now.
Re: Workflow Instance Store
I have an instance correlation cofigured based on some int ID parameter passed into receive activity.Could you please describe your scenario?
I would like to be able to understand which stored instance is associated with which ID.
I assume that this data is stored in BLOB fields, including parameters, etc., so I would like to be able to read and update that data in case of any emergency situation with workflow.
Re: Workflow Instance Store
One more question I have:
It seems like tracking information is put into DB by one row each time.
Is there any way to do bulk update to DB instead of saving tracking info row by row?
It seems like tracking information is put into DB by one row each time.
Is there any way to do bulk update to DB instead of saving tracking info row by row?
Re: Workflow Instance Store
Please use the ADO.NET classes.Partizan wrote:I would like to be able to read and update that data
Our WF functionality doesn't include the batching feature.Partizan wrote:It seems like tracking information is put into DB by one row each time.
Is there any way to do bulk update to DB instead of saving tracking info row by row?