Parameters—Execute Immediate Statement
This statement has the following parameters:
statement_string
Specifies a string literal, a varchar expression, or a reference variable of class StringObject. The statement string cannot contain more than one statement. The varchar expression should be declared not null, or there will be compiler warnings.
It also cannot contain a Dynamic SQL statement or any of the following SQL statements:
• call
• close
• connect
• declare
• disconnect
• execute immediate
• fetch
• include
• inquire_sql
• open
• prepare to commit
• set_ingres
• whenever
Because the Value attribute of the StringObject will be passed to the command, it will be limited to 2000 characters. For more information, see the StringObject class
Value attribute (see
Value Attribute).
variable
Specifies the variable that holds the value of the select statement. The number and data types of these variables must match the number and data types of the values returned by the select statement.
beginendblock