statement_name block_name
is the identifier to be associated with the prepared SQL statement or PL/SQL block. If this name has been previously assigned to another statement or block, the prior assignment is superseded.
:host_string
is a host variable whose value is the text of a SQL statement or PL/SQL block to be prepared.
'text'
is a string literal containing a SQL statement or PL/SQL block to be prepared.
A SQL statement is prepared only once, but can be executed any number of times.
Example
This example illustrates the use of a PREPARE statement in a Pro*C embedded SQL program:
EXEC SQL PREPARE my_statement FROM :my_string;
EXEC SQL EXECUTE my_statement