ADO Execute SQL - Oracle

Automise Discussion
1

Hi All,

I have tried to execute an update SQL to an Oracle using the ADO Execute SQL tool.... I have tried with all possible providers fro Oracle, but the result is the same. I have checked the SQL string in Toad, and there it works fine. In Automise, it keeps runnning for ever.. I break after 1 minute.. and this a simple update...  UPDATE REPORT_REPORTITEM SET REPORTEDDATE = SYSDATE WHERE REPORTEDDATE IS NULL AND PROJECTID = '%PROJECTID%'.. no rocket science... :-)

This is the last item in my automise script and I would expect it to close when done.

Any ideas?

2

try a normal select and see if that works, and also try without the parameter and see if that makes any difference.

3

are you loading the SQL from a file or typing it in the text field?

Also what version of Automise are you using?

4

Removing one of the parameters in the where made it work... still one other abnormality in the script though... the query ends with an error saying no more results.. the table is updated though, but I need the other parameter as well... otherwise the date/time stamps will not be correct.

I am using version 2.0.0.176