waitforresult

Syntax

waitforresult expected_result timeoutseconds searchrow searchcol sqlstatement

Description

Similar to the waitfor command, except that the result can have one or more columns. Also, the result can return 0 rows.

Runs the given statement once a second until the query returns the expected result or a timeout occurs. The searchrow and searchcol arguments indicate the ordinal position (1..N) of which row or column should be considered. Use '*' in searchrow or searchcol to indicate any row or column of the result set could have the expected value. See the waitfor command.

Examples

Command> waitforresult 1 5 * * select * from dual;
Waitforresult: Time expired.
The command failed.

At verbosity level 4, you can retrieve the result values that it is using to compare against in order to diagnose why the matching of the value is not successful.

Command> verbosity 4;
The command succeeded.

Command> waitforresult 1 5 * * select * from dual;
Value is 'X'
Value is 'X'
Value is 'X'
Value is 'X'
Value is 'X'
Waitforresult: Time expired.
The command failed.