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)