exec

Syntax

exec [connect_id.] command_id] | PLSQLSTMT

Description

Runs the prepared command command_id on connection connect_id or runs a PL/SQL 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.