Blue Prism Product

Hi Team,

I'm using Data - Oracle (MDA) VBA to execute the one of the Query to alter the package but it's giving the error like Operation is not valid due to the current state of the object. and I'm using the Execute Action from the VBO.
My Query looks like this for example
alter package ABCD_XYZ_ODI_PROCESS compile body

if I run the same query from the Oracle SQL it's giving the result for me


Could you please help on this?

HI Syed,

Thank you for being a SSC Blue Prism Customer and for using Blue Prism. I am sorry you are experiencing issues with the Oracle VBO.

Can we establish some initial setup parameters?

1. Are you using Oracle 21c?
2. In your process, have you set the connection parameters to connect to your Oracle system?
3. Have you tried executing a very simple SQL statement to see if it returns correctly?
4. Do you have a transaction set up for this action?

If you can come back to me with answers to the above I will see what we can resolve for you.

Once again, thank you for using Blue Prism and for being an SSC Blue Prism customer.
regards

Hi Team,

I'm using Data - Oracle (MDA) VBA to execute the one of the Query to alter the package but it's giving the error like Operation is not valid due to the current state of the object. and I'm using the Execute Action from the VBO.
My Query looks like this for example
alter package ABCD_XYZ_ODI_PROCESS compile body

if I run the same query from the Oracle SQL it's giving the result for me


Could you please help on this?

Hi Geoff,

Thank you for your response.
1. Are you using Oracle 21c? 
We are using the Oracle SQL Developer 

2. In your process, have you set the connection parameters to connect to your Oracle system?
Yes we have set the connection parameters and it's working perfectly

3. Have you tried executing a very simple SQL statement to see if it returns correctly?
We are already using this for Select Query and it is working perfectly

4. Do you have a transaction set up for this action?
Yes, We have all the Transaction Set up in the oracle SQL Developer and if I run the Query in the Oracle SQL Developer i's giving the results and if I run the same query with Blue Prism I'm getting the error as I mentioned in my post.

Could you please help us here?

HI Syed,

Thank you for being a SSC Blue Prism Customer and for using Blue Prism. I am sorry you are experiencing issues with the Oracle VBO.

Can we establish some initial setup parameters?

1. Are you using Oracle 21c?
2. In your process, have you set the connection parameters to connect to your Oracle system?
3. Have you tried executing a very simple SQL statement to see if it returns correctly?
4. Do you have a transaction set up for this action?

If you can come back to me with answers to the above I will see what we can resolve for you.

Once again, thank you for using Blue Prism and for being an SSC Blue Prism customer.
regards

Hi Team,

I'm using Data - Oracle (MDA) VBA to execute the one of the Query to alter the package but it's giving the error like Operation is not valid due to the current state of the object. and I'm using the Execute Action from the VBO.
My Query looks like this for example
alter package ABCD_XYZ_ODI_PROCESS compile body

if I run the same query from the Oracle SQL it's giving the result for me


Could you please help on this?

Hi Geoff,

Thank you for your response.
1. Are you using Oracle 21c? 
We are using the Oracle SQL Developer 

2. In your process, have you set the connection parameters to connect to your Oracle system?
Yes we have set the connection parameters and it's working perfectly

3. Have you tried executing a very simple SQL statement to see if it returns correctly?
We are already using this for Select Query and it is working perfectly

4. Do you have a transaction set up for this action?
Yes, We have all the Transaction Set up in the oracle SQL Developer and if I run the Query in the Oracle SQL Developer i's giving the results and if I run the same query with Blue Prism I'm getting the error as I mentioned in my post.

Could you please help us here?

HI Syed,

Thank you for being a SSC Blue Prism Customer and for using Blue Prism. I am sorry you are experiencing issues with the Oracle VBO.

Can we establish some initial setup parameters?

1. Are you using Oracle 21c?
2. In your process, have you set the connection parameters to connect to your Oracle system?
3. Have you tried executing a very simple SQL statement to see if it returns correctly?
4. Do you have a transaction set up for this action?

If you can come back to me with answers to the above I will see what we can resolve for you.

Once again, thank you for using Blue Prism and for being an SSC Blue Prism customer.
regards

Hi Team,

I'm using Data - Oracle (MDA) VBA to execute the one of the Query to alter the package but it's giving the error like Operation is not valid due to the current state of the object. and I'm using the Execute Action from the VBO.
My Query looks like this for example
alter package ABCD_XYZ_ODI_PROCESS compile body

if I run the same query from the Oracle SQL it's giving the result for me


Could you please help on this?

Hi Syed,

I have been working on your problem and I have discovered an issue with the asset, in particular the execute. I have made some additions to the asset and updated the example process. I will be updating the documentation soon and then I will post this update to the Digital Exchange. Once it has cleared QA it will be available for download. I expect this to be in the next few days, possibly early next week. 

Sorry for the inconvenience.

regards

Hi Geoff,

Thank you for your response.
1. Are you using Oracle 21c? 
We are using the Oracle SQL Developer 

2. In your process, have you set the connection parameters to connect to your Oracle system?
Yes we have set the connection parameters and it's working perfectly

3. Have you tried executing a very simple SQL statement to see if it returns correctly?
We are already using this for Select Query and it is working perfectly

4. Do you have a transaction set up for this action?
Yes, We have all the Transaction Set up in the oracle SQL Developer and if I run the Query in the Oracle SQL Developer i's giving the results and if I run the same query with Blue Prism I'm getting the error as I mentioned in my post.

Could you please help us here?

HI Syed,

Thank you for being a SSC Blue Prism Customer and for using Blue Prism. I am sorry you are experiencing issues with the Oracle VBO.

Can we establish some initial setup parameters?

1. Are you using Oracle 21c?
2. In your process, have you set the connection parameters to connect to your Oracle system?
3. Have you tried executing a very simple SQL statement to see if it returns correctly?
4. Do you have a transaction set up for this action?

If you can come back to me with answers to the above I will see what we can resolve for you.

Once again, thank you for using Blue Prism and for being an SSC Blue Prism customer.
regards

Hi Team,

I'm using Data - Oracle (MDA) VBA to execute the one of the Query to alter the package but it's giving the error like Operation is not valid due to the current state of the object. and I'm using the Execute Action from the VBO.
My Query looks like this for example
alter package ABCD_XYZ_ODI_PROCESS compile body

if I run the same query from the Oracle SQL it's giving the result for me


Could you please help on this?

Hi Geoff 

Thank you for the Update.

Could you please let me know once it's available in Digital Exchange?

Hi Syed,

I have been working on your problem and I have discovered an issue with the asset, in particular the execute. I have made some additions to the asset and updated the example process. I will be updating the documentation soon and then I will post this update to the Digital Exchange. Once it has cleared QA it will be available for download. I expect this to be in the next few days, possibly early next week. 

Sorry for the inconvenience.

regards

Hi Geoff,

Thank you for your response.
1. Are you using Oracle 21c? 
We are using the Oracle SQL Developer 

2. In your process, have you set the connection parameters to connect to your Oracle system?
Yes we have set the connection parameters and it's working perfectly

3. Have you tried executing a very simple SQL statement to see if it returns correctly?
We are already using this for Select Query and it is working perfectly

4. Do you have a transaction set up for this action?
Yes, We have all the Transaction Set up in the oracle SQL Developer and if I run the Query in the Oracle SQL Developer i's giving the results and if I run the same query with Blue Prism I'm getting the error as I mentioned in my post.

Could you please help us here?

HI Syed,

Thank you for being a SSC Blue Prism Customer and for using Blue Prism. I am sorry you are experiencing issues with the Oracle VBO.

Can we establish some initial setup parameters?

1. Are you using Oracle 21c?
2. In your process, have you set the connection parameters to connect to your Oracle system?
3. Have you tried executing a very simple SQL statement to see if it returns correctly?
4. Do you have a transaction set up for this action?

If you can come back to me with answers to the above I will see what we can resolve for you.

Once again, thank you for using Blue Prism and for being an SSC Blue Prism customer.
regards

Hi Team,

I'm using Data - Oracle (MDA) VBA to execute the one of the Query to alter the package but it's giving the error like Operation is not valid due to the current state of the object. and I'm using the Execute Action from the VBO.
My Query looks like this for example
alter package ABCD_XYZ_ODI_PROCESS compile body

if I run the same query from the Oracle SQL it's giving the result for me


Could you please help on this?

Syed,

As requested, the Oracle MDA asset has now been updated on the DX. Please could you feedback your experience to this thread with the new version. I did test it with similar activity to what you were trying to undertake and it performed satisfactorily in my case.

regards

Hi Geoff 

Thank you for the Update.

Could you please let me know once it's available in Digital Exchange?

Hi Syed,

I have been working on your problem and I have discovered an issue with the asset, in particular the execute. I have made some additions to the asset and updated the example process. I will be updating the documentation soon and then I will post this update to the Digital Exchange. Once it has cleared QA it will be available for download. I expect this to be in the next few days, possibly early next week. 

Sorry for the inconvenience.

regards

Hi Geoff,

Thank you for your response.
1. Are you using Oracle 21c? 
We are using the Oracle SQL Developer 

2. In your process, have you set the connection parameters to connect to your Oracle system?
Yes we have set the connection parameters and it's working perfectly

3. Have you tried executing a very simple SQL statement to see if it returns correctly?
We are already using this for Select Query and it is working perfectly

4. Do you have a transaction set up for this action?
Yes, We have all the Transaction Set up in the oracle SQL Developer and if I run the Query in the Oracle SQL Developer i's giving the results and if I run the same query with Blue Prism I'm getting the error as I mentioned in my post.

Could you please help us here?

HI Syed,

Thank you for being a SSC Blue Prism Customer and for using Blue Prism. I am sorry you are experiencing issues with the Oracle VBO.

Can we establish some initial setup parameters?

1. Are you using Oracle 21c?
2. In your process, have you set the connection parameters to connect to your Oracle system?
3. Have you tried executing a very simple SQL statement to see if it returns correctly?
4. Do you have a transaction set up for this action?

If you can come back to me with answers to the above I will see what we can resolve for you.

Once again, thank you for using Blue Prism and for being an SSC Blue Prism customer.
regards

Hi Team,

I'm using Data - Oracle (MDA) VBA to execute the one of the Query to alter the package but it's giving the error like Operation is not valid due to the current state of the object. and I'm using the Execute Action from the VBO.
My Query looks like this for example
alter package ABCD_XYZ_ODI_PROCESS compile body

if I run the same query from the Oracle SQL it's giving the result for me


Could you please help on this?