create procedure TEST dynamic results sets p1: begin begin execute immediate' create table abc ( empid numeric ); end;