Restrictions on deferred-PREPARE
When you enable the deferred-PREPARE feature, the client application does not send PREPARE statements to the database server when it encounters them. The database server receives a description of the prepared statement when it executes the OPEN statement.
The
database server generates an error if you execute a DESCRIBE statement
on a prepared statement before the first OPEN of the cursor. The error
occurs because the database server has not executed the PREPARE statement
that the DESCRIBE statement specifies. When the deferred-PREPARE feature
is enabled, you must execute the DESCRIBE statement after the first OPEN
of a cursor.
Important: The deferred-PREPARE feature eliminates
execution of the PREPARE statement as a separate step. Therefore,
the application does not receive any error conditions that might exist
in the prepared statement until after the initial OPEN.