can we use multiple sql statements in a procedure?

[srinivasm]

Hi Jeff Hunter,

I tried the way as you said. but even though i am getting copilation errors

i tried like this

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

Warning: Procedure created with compilation errors.


and i tried again like this

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

Warning: Procedure created with compilation errors.

help me

SrinivasM