Hi friends,

can we use multiple sql statements in a procedure?

I trued like this

SQL> create procedure proctab1 (table1 in varchar2,table2 in varchar2)
2 as
3 begin
4 execute immediate
5 'create table ' || table1 || ' (name varchar2(10))' ,
6 'create table ' || table2 || ' (name varchar2(10))';
7 end;
8 /

Warning: Procedure created with compilation errors.


if anybody knows the correct syntax please help me

regards

SrinivasM