Methods described in this chapter are applied to the PREPARED data type.
Cursor is treated as an object associated with a variable. This makes a prepared statement more flexible.
Unlike a prepared statement declared implicitly with the help of the PREPARE statement which has only the module scope of reference, a PREPARED variable can be declared with any scope of reference
Variables of the PREPARED data type can be passed to functions and returned by them.
Available methods:
|
executes variable-associated prepared statements and returns output values, if any |
|
|
frees the memory allocated to the prepared statement and makes it possible to use the PREPARED variable to prepare SQL statements |
|
|
retrieves the name of a prepared statement |
|
|
returns text of the SQL statement which have been prepared using the prepare() method |
|
|
verifies whether the SQL statement was prepared natively |
|
|
initializes a variable of the PREPARED data type and prepares an SQL statement for the execution in the RDBMS |
|
|
supplies values for substituting placeholders, if any |
|
|
changes the output values produced by the prepared statement |