plsql-reg [message #37119] |
Fri, 18 January 2002 20:02 |
Nantha
Messages: 4 Registered: December 2001
|
Junior Member |
|
|
Hi all,
I am Nantha from Chennai,India.
I have one doubt in plsql program. Is there any possibility to use the DDL statements inside the body of the program?.
Please give me answer.
Thanks in advance
|
|
|
Re: plsql-reg [message #37127 is a reply to message #37119] |
Sat, 19 January 2002 08:25 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
yes, you have to use dynamic sql for that
ex:
create or replace procedure p1 is
begin
execute immediate 'create table xyz(x number)';
end;
|
|
|
Re: plsql-reg [message #37155 is a reply to message #37119] |
Mon, 21 January 2002 18:38 |
Satish Shrikhande
Messages: 167 Registered: October 2001
|
Senior Member |
|
|
Hi nantha
This is Satish From Pune,India .
Now if you are using lower than 8i you need to use DBMS_SQL for executing DDL in subprograms and for Oracle 8i and above , Suresh has given you the answer .
Cya
|
|
|