7. Using Repeat Queries with OpenAPI : Repeat Query Parameters : Example: Repeat query using the $n = ~V marker
Share this page                  
Example: Repeat query using the $n = ~V marker
The query from the previous section, if used as a repeat query would be:
select * from employee where dept = $0 = ~V and age > $1 = ~V
When implementing repeat queries, parameter values must be sent when the repeat query is defined, as well as when the query is invoked. Query text is not sent when a repeat query is invoked, but the parameters sent at invocation must be in the same order as when the repeat query was defined.
More information:
How the ~V Mechanism Works