waitfor

Syntax

waitfor expected_result timeoutseconds sqlstatement

Description

Runs the given statement once a second until the query returns the expected result or a timeout occurs. The query must have only one column and must return exactly one row. Any errors in the query terminate the loop.

Note:

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.

Examples

Command> waitfor X 10 select * from dual;

Command> verbosity 4;
The command succeeded.

Command> waitfor X 10 select * from dual;
Value is 'X'
The command succeeded.