| 22. 16. 1. Simple EXECUTE IMMEDIATE |
|
|
The EXECUTE IMMEDIATE command can be |
- a VARCHAR2 variable,
- a literal quoted string, or
- any string expression.
|
|
begin
execute immediate 'whatever_text_string_you_want';
end;
|
|
or |
|
declare
v_variable_tx VARCHAR2(32000);
begin
v_variable_tx:='whatever_you_want';
execute immediate v_variable_tx;
end;
|
|
The code to be executed can be passed as a variable or directly as a string in the command. |
The string cannot exceed 32K. |
The code can be a single SQL command or a large block of PL/SQL. |
All PL/SQL blocks passed as a string should have a semicolon at the end, as shown here: execute immediate 'begin p_test; end;'; |
All SQL statements passed as a string should not have a semicolon at the end, as shown here: execute immediate 'select 1 from dual' into a; |