-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|