User Sean du Plessis ( posted:


I have written a script (.rec) in Robot that creates a connection to a
database (Oracle in this case) using one of the ODBC connections. It then
runs a query on the database, retrieves the information and verifies it
against bench data stored in variables passing or failing the test with
sqaPass and sqaFail.

My problem is this: I am able to retrieve the data from the database and
compare it successfully with the bench data on the one database (some
pass and some fail as they should). But when I run the same script on
a different database, no data is retrieved by the script thus making all
verification instructions sqaFail. When logging in through SQL
Plus to this database and running the same query on it, the data is in fact
there and visible.

Please help.


Sean du Plessis
IT Tester
Medscheme IT
*+27 11 510 2424

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++
Everything in this e-mail and attachments relating to the official business
of Medscheme Holdings ( Pty ) Ltd ( Reg Number 1970/015014/07 ) is
proprietary to the company. It is confidential, legally privileged and
protected by law. Medscheme Holdings does not own and endorse any other
content. Views and opinions are those of the sender unless clearly stated as
being that of Medscheme Holdings. The person addressed in the e-mail is the
sole authorised recipient. Please notify the sender immediately if it has
unintentionally reached you and do not read, disclose or use the content in
any way. Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information and data transmitted electronically and to preserve
the confidentiality thereof, no liability or responsibility whatsoever is
accepted if information or data is,for whatever reason, corrupted or does
not reach its intended destination.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++