execandfetch

Syntax

execandfetch [[connect_id.]command_id]

Description

Executes the specified prepared SQL statement and fetches all result rows associated with the statement.

The connect_id optionally names a ttIsql connection and command_id is an integer from 1 to 255. If PLSQLSTMT is supplied, ttIsql prepends the statement with BEGIN and appends the statement with END, thus allowing the PL/SQL statement to run.

If no argument is supplied, runs the most recent command.

For examples, see Prepare a SQL Statement for Subsequent Runs.