You cannot specify the following SQL DML statements in an SQL procedure.
- CHECKPOINT
- COLLECT DEMOGRAPHICS
- DUMP EXPLAIN
- ECHO
- INITIATE INDEX ANALYSIS
- INITIATE PARTITION ANALYSIS
|
- INSERT EXPLAIN
- RESTART INDEX ANALYSIS
- SELECT (outside of a cursor)
- SELECT AND CONSUME
- SELECT AND CONSUME (in updatable cursors)
|