Forum Discussion

linda_marshall's avatar
linda_marshall
Occasional Contributor
11 years ago

How do I update a database (Oracle) from a keyword test?

  I want to access an Oracle database through a Keyword Test (which I can do, for comparisons, from the Database Checkpoint) and update a table. So far, I've not been able to work out how to do this.

 

Some background information:

  This would be part of a group of data set up scripts that are being automated. Apart from one item of data the application data can be updated throught he GUI, so no problem with keyword tests. At present this one data item is updated 'manually' through a SQL update (this is a step in the manual test script). It would be nice to be able to include a script to update this item in the group of automated scripts.

 

  I'm concentrating on the use of Keyword Scripts to keep things simple whilst getting used to using the tool, and so that other testers without coding experience can follow them.

1 Reply

  • colinstrydom's avatar
    colinstrydom
    Occasional Contributor
    11 years ago

    I can help you do this via scripting. Let me know if you still need a solution to this.

     

    The best idea would building a function/procedure that connects to the oracle database, and a SQL file location and name as a parameter. This means other testers can just re-use the function, and simply change the script file location.