Illegal Direct Execute Immediate Statements
The following statements are not allowed for direct execute immediate:
• Preprocessor directives:
begin declare section
declare
end declare section
include
whenever
• Cursor statements:
open
close
fetch
• Row returning statements:
select
endselect
• Non-database statements:
call
inquire_sql
set_sql
• Transaction statements:
commit
rollback
savepoint
set autocommit on
• Other statements:
connect
disconnect
describe
direct connect
direct disconnect
execute
execute immediate
help
prepare
repeat queries
register as link